How to freeze placement of Small Multiples Category in a Clustered Column Chart

[Roseventura]

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.

[Syk · Accepted solution]

4 years late but I found this trying to do the exact same thing. You CAN lock the position of your small multiples but it has to be with your data, not with a setting. You need to adjust one of your measures (or create a new one) like Sales TYTD to have an if statement.

Sales TYTD Blank Handler = IF(ISBLANK([Sales TYTD]),0,[Sales TYTD])

Typically if there is blank data your small multiple will just be removed and the cards you overlayed will be mismatched. With this measure, even if its blank you will still see your small multiple as a 0. Hope this helps someone else who may stumble on this question with a dismissive answer.

[lbendlin]

No need to calculate the measure twice. Use COALESCE.

[lbendlin]

the answer remains no.  What you are trying to do is defeating the purpose of small multiples (and "responsive design") a little bit.

[Roseventura]

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

[lbendlin]

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".