Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
75 | |
63 | |
62 |
User | Count |
---|---|
143 | |
104 | |
103 | |
82 | |
66 |