Small Multiples - Skip Blanks in Bar Charts

I have a dataset that has sales performance by rep, and a column that shows the rep region. I want to make small multiples in the form of a bar graph with the multiples driven by region, but when I do I have odd blanks for reps that are in the data but not in that region, is there a better way to set this up so each bar chart only shows non-zero values?

I don’t believe this is possible yet.

It’s a similar concept to how pivot tables can show nulls but you can’t hide the row and column without hiding the entire row or column.

I can mark it as a feature request.

1 Like