Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a card that gives a number based on my query. On the page, i have two slicers, a Date slicer and a Category Slicer. Is it possible to change the Card value based on just the Category Slicer and not change , if the Date slicer were to be updated.
The formula for the Card i have is
Solved! Go to Solution.
Yes there is.
In the desktop version go to "format" in the menu, then click on edit interactions. You can then turn off visual from filtering each other (a slicer is of course a visual).
So you click on the slicer, and then turn off the interaction on the visual you want.
Thanks,
Hi @PBI5851 ,
You may use "Edit interactions" feature to choose which visuals to be filtered by one special visual, follow steps below.
Reference:
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions .
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Refer the below links for edit interaction:
https://radacad.com/control-the-interaction-in-power-bi-report
Hi @PBI5851 ,
In Desktop, you can use the Edit Interactions function to turn on/off which slicers and which visuals interact with each other.
Proud to be a Datanaut!
Private message me for consulting or training needs.
Yes there is.
In the desktop version go to "format" in the menu, then click on edit interactions. You can then turn off visual from filtering each other (a slicer is of course a visual).
So you click on the slicer, and then turn off the interaction on the visual you want.
Thanks,
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |