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 betwe...
Need Help
v-xicai's avatar
v-xicai
Icon for Community Support rankCommunity 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
    Icon for Microsoft Employee rankMicrosoft 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?