topic Re: Slicer based on Column header in DAX Commands and Tips

Slicer based on Column header

wheelsshark — Mon, 24 Apr 2023 02:57:38 GMT

Hi,

I have a table

RollNo	Name	Game1	Game2	Game3	Region	Total Score
1	Tom	0	3	3	aa	6
2	Neil	3	1	1	aa	5
3	bob	0	0	2	bb	2
4	Harry	3	0	0	bb	3
5	Mac	0	2	1	cc	3

Here I have added a slicer tile with regions, below i have added chard cards and tables. All works well

But i want to add one more slicer with Game1, Game 2, Game3. This slicer should also affect the below visuals.

ex - on selecting Game 1 - should show only Neil and Harry.

I tried unpivot, that confuses all other calculations. is there any other simpler way to achieve this?

Re: Slicer based on Column header

Jihwan_Kim — Mon, 24 Apr 2023 03:10:00 GMT

Hi,

One of ways to achieve this is using a field parameters feature.
Please check the link down below that is the documentation from Microsoft.

Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Re: Slicer based on Column header

wheelsshark — Thu, 27 Apr 2023 22:55:49 GMT

Thank you for your help. I tried field parameters. I dont think that helps in my example. i understand field parameter changes the slicer option from one to another. But here i need one more new slicer with those column names. Game1, Game2, Game3.

Can you please help me with a solution