How to display multiple columns as a filter on a chart

[liu]

My table is set up with columns of different regions (Central, West, etc.) and their monthly ticket volume in rows.

Is there a way for me to create a chart with Region as a filter? Example, if a user selected 'Central', the chart would display the month-over-month ticket volume of Central region?

[MFelix · Accepted solution]

Hi @liu,

On query editor select your columns and unpivot them, you will have 3 columns:
- Date
- Category
- Values

Then just add the Category column to a slicer and date and value to your chart you will then get the expected result.

Regards,
MFelix