Forum Discussion
How to add column headers into Slicer.
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.
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
1 Reply
- BA_Pete
Super User
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