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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

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
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.