Forum Discussion

bi_newww's avatar
bi_newww
New Member
5 years ago
Solved

How to create a slicer to filter multiple column headers

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 ...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

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

  • mussaenda's avatar
    mussaenda
    5 years ago

    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's avatar
Ashish_Mathur
Super User
5 years ago

Hi,

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