Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Create slicer based on multiple column headers

Hi everyone,

 

Is it possible to create one slicer including several column headers (without unpivoting those columns)? 

For example, if there are four headers, and you want to easily switch between those columns, how can that be done?

 

NPSCESJoyGeneral
86.57.86
76.887
7.7797
668.56.2
7968
Need Help

4 Replies

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    You may create a new table via button "Enter data", which contains the column names NPS,  CES,  Joy and General, assuming this new column is named [Column header]. Then create a calculated column to as the source of slicer visual.

     

    SelectedColumn=

Var d= SELECTEDVALUE(Table[Column header])

Return

SWITCH(d, "NPS", 'Data'[NPS], "CES", 'Data'[CES], "Joy", 'Data'[Joy], "General", 'Data'[General] )

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • FatBlackCat30's avatar
      FatBlackCat30
      Microsoft Employee
      5 years ago

      v-xicai I am trying to do this in my file and its not working. Do you happen to have a sample file with this example?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi v-xicai ,

     

    Thanks for your reply.

    At the end, I did unpivot the columns. So, the issue is solved.