How to create a slicer to filter multiple column headers

[bi_newww]

Hi all, I am really stuck trying to create 1 slicer that can filter the column values and show the desired selection on the line chart.

Basically, the slicer should have 6 options - 1) GCAN3M Index and 2) GCAN6M Index and so on. When the user clicks on "GCAN3M Index" for example, only the value under GCAN3M Index should be filtered and show on the chart. I can't seem to make this work by creating a new table that contains the column headers and a new measure to link it. Thanks in advance for your help!

[Ashish_Mathur · Accepted solution]

Hi,

The data is not well structured.  RIght click on the Date column and select "Unpivot other columns".

[mussaenda · Accepted solution]

Hi @bi_newww ,

you can unpivot your data so you can use the column headers as slicer.

If you need a smple output, please provide a sample data where we can copy.

Thanks.

Hope this helps.

[Ashish_Mathur · Accepted solution]

Hi,

The data is not well structured.  RIght click on the Date column and select "Unpivot other columns".