How to add column headers into Slicer.

[sidd_xp]

I need help in creating a slicer containing values as column headers.

For example, I have headers Q1_2018, Q2_2018 etc and want these into slicer to filter the graphs accordingly.

[BA_Pete · Accepted solution]

Hi @sidd_xp ,

If you have access to this table in Power Query, you should multi-select columns [Country Name] to [ROAA_Remarks] (or basically any column that isn't  'QX_YYYY' column), then go to Transform tab > Unpivot columns (dropdown) > Unpivot Other Columns.

This will structure your data correctly for Power BI reporting.

Pete