Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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?
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
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
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 10 | |
| 9 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 32 | |
| 31 | |
| 18 | |
| 12 | |
| 11 |