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 am trying to filter data on a PBI report on the product dimension. I am trying to get the three boxes that currently display 324 each to show:
Bikes = 150
Cars = 114
Buses = 60
But, without actually clicking on a filter.
I have tried Page Filter and Report filter, but it applies the filter to all the objects on the page.
Solved! Go to Solution.
Hey @Steves2,
this describes it pretty good
But in the meantime ´the icon has moved to another location:
Don't forget to disable the Interaction Mode, sometimes it takes me seconds wondering why my visuals won't work as usual 🙂
I use this quite often, whenever I want a visual to display a certain value, no matter what the audience is selecting on other viisuals or slicers, this helps me to avoid a measure that has the sole purpose to work on a visual, and in addition this measure will clutter up the fields list.
Regards
Tom
Hey,
just mark one of the cards, add the column to the "Visual level filters" like in the image below, and select the element you want to use as filter:
Repeat the steps for the other two cards, and you're done-
You may consider, to break the interaction with other visuals, to make sure the cards always show what you want.
Regards
Tom
Thank you Tom, this seems to work.
Could I ask, how do you break the interactions with the other visuals?
Regards
Steve
Hey @Steves2,
this describes it pretty good
But in the meantime ´the icon has moved to another location:
Don't forget to disable the Interaction Mode, sometimes it takes me seconds wondering why my visuals won't work as usual 🙂
I use this quite often, whenever I want a visual to display a certain value, no matter what the audience is selecting on other viisuals or slicers, this helps me to avoid a measure that has the sole purpose to work on a visual, and in addition this measure will clutter up the fields list.
Regards
Tom
Thank you so much Tom. You've been very helpful
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 |
---|---|
111 | |
94 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |