Create slicer based on multiple column headers

[Anonymous]

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?

NPS	CES	Joy	General
8	6.5	7.8	6
7	6.8	8	7
7.7	7	9	7
6	6	8.5	6.2
7	9	6	8

[Anonymous]

Hi @v-xicai ,

Thanks for your reply.

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

[v-xicai]

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]

@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?

[amitchandak]

@Anonymous , refer if this can help

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115