How to create dynamic dashboards based on sub categories in a single column

I have some data similar to this structure and i want to create dashboards based on the sub categories (like XXXXX is one type of category)
Screenshot_20221125_103016
and this is how i want part of my dashboard to look like (with bar graph only showing the selected customerid in x-axis)
expectedresult
I am new to data visualization, so please ignore if this is a dumb question.
Thank you in advance

Hi @arun,

To do this you can do the following:

  1. Load the data in to QuickSight.
  2. Create a bar chart based off item_id and price - decide if you want price to be sum, avg, min, max etc…
  3. Create a parameter for customer id.
  4. Add the parameter as a control on the sheet.
  5. Add the parameter in a filter - to do this select custom filter, then check use parameter.

You can’t show the selected ‘customer id’ in the x-axis, but you can include the value of the parameter in the visual title.

Let me know if that helps.

1 Like

Thank you so much, it worked.

2 Likes

So glad you found a solution @arun! Thanks @robkc for helping the Community out! :slight_smile:

1 Like