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
Power BI DataViz World Championships

Power BI Dataviz World Championships

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

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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.