Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
wheelsshark
Frequent Visitor

Slicer based on Column header

Hi,

I have a table

RollNoNameGame1Game2Game3RegionTotal Score
1Tom033aa6
2Neil311aa5
3bob002bb2
4Harry300bb3
5Mac021cc3

 

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

wheelsshark_0-1682305047071.png

 

 

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?

 

2 REPLIES 2
Jihwan_Kim
Super User
Super User

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

 


If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.


Click here to visit my LinkedIn page

Click here to schedule a short Teams meeting to discuss your question.

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.