Forum Discussion
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...
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.
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?