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.
Is there a way to freeze the where the small multiples categories appear in the clustered column chart?
I added cards that displays YoY Growth for each Category (I have 5: Commercial, Defense, Other, Rail, and Space).
What's happening is if someone filters on a category, that category moves in the clustered column chart. I want each category to stay where it is.
In this picture, it shows where each category is and the card placement above it.
But as soon as someone filters on one of the categories (i.e., Rail), it moves that bar chart to the top and the cards no longer correlate to the bar chart.
Is there a way to "lock" the placement of each category? Why does it move to the top? And also, since I'm only filtering on "RAIL" in this example, why is "OTHER" still showing?
Any help would be greatly appreciated.
Solved! Go to Solution.
There is no way to lock this. Your column chart visual has no idea that there are card visuals layered on top.
You may not be filtering by the same field, or your measure may modify the filter context to still show "Other".
the answer remains no. What you are trying to do is defeating the purpose of small multiples (and "responsive design") a little bit.
Ok, let's forget the fact that I have card visuals overlaying the small multiples chart.
Here's my question: Is there a way to lock the location of each of the categories in a small multiples visual to prevent them from moving around when you use a filter?
Rose
There is no way to lock this. Your column chart visual has no idea that there are card visuals layered on top.
You may not be filtering by the same field, or your measure may modify the filter context to still show "Other".
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 |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |