Forum Discussion

liu's avatar
liu
Regular Visitor
8 years ago
Solved

How to display multiple columns as a filter on a chart

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?

 

 

 

Need Help
  • MFelix's avatar
    MFelix
    8 years ago
    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

1 Reply

  • MFelix's avatar
    MFelix
    Icon for Super User rankSuper User
    8 years ago
    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