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.
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,
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 |
---|---|
105 | |
94 | |
75 | |
63 | |
62 |
User | Count |
---|---|
137 | |
105 | |
104 | |
80 | |
63 |