Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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!
User | Count |
---|---|
106 | |
85 | |
81 | |
73 | |
71 |
User | Count |
---|---|
111 | |
102 | |
97 | |
74 | |
67 |