Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi experts,
I have the following table:
KPI | Coin | Value |
Sales | Local | 100 |
Sales | Foreign | 200 |
Units sold | No coin | 50 |
With two slicers (KPI, Coin) and one measure.
When I select Coin = "Local" or Coin = "Foreign", "Sales" is shown in the KPI slicer, as they belong to each other in the table. Neverthless, when I select Coin = Local or Coin = Foreign, the option in KPI slicer "Units sold" disappeared as it has a non selected value in Coin slicer. I wonder if there's a trick I can use in order to show "Units sold" in the KPI slicer eventhough the selected filter "Coin" (Local or Foreing) doesn't belong to it.
I don't want to use the Coin = "No coin" option because when I select this alternative, "Sales" disappears in the KPI slicer, and I want the two values ("Sales", "Units sold") to be visible in spite of the Coin filter
Solved! Go to Solution.
You'll need to turn off visual interactions between your slicer(s).
There's a page here on how that works: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...
You'll need to turn off visual interactions between your slicer(s).
There's a page here on how that works: https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...
Omg I didn't know it existed. Thank you!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
83 | |
64 | |
60 | |
55 |
User | Count |
---|---|
179 | |
108 | |
105 | |
71 | |
70 |