Stacked column chart with small multiples - hide items on X-Axis that do not belong to category

[Mats91]

Hi everyone,

I am trying to compare the performance of individual items. Each item belongs to one category.

When using the stacked column chart, for each category (I use the field in the "small multiple" section) all items on the x-axis are listed, even though they all belong to just one category.

The "Show items with no data" setting is off for the field(s) used on the X-axis.

So basically: How can I adjust the configuration of the visual to only compare the items as follows:

"App A1" with "App B2" for the category "Activity"

"App A3" with "App B4" for the category "Execution"

"App A5" with "App B6" for the category "Frequency"

Sample Data:

Application	Category	Item	Value	Value
App A	Activity	1	0,76	0.76
App B	Activity	2	0,88	0.88
App A	Execution	3	0,54	0.54
App B	Execution	4	0,61	0.61
App A	Frequency	5	0,91	0.91
App B	Frequency	6	0,22	0.22

[v-xinruzhu-msft · Accepted solution]

Hi @Mats91 

After testing, it cannot hide the blank value of each category. Because the value of the blank item is not blank in other category. e.g the APPA3  and APPB1 is blank in Activity, but it is not blank in Execution. they use the same x-axis, so it cannot hide. If you want to compare them , maybe you can conder to create four visuals just display the related value of each category.

e.g 

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Mats91]

Thank you for checking and for the suggested workaround - I will split the visual by the dimension category and harmonize the Y-axis scaling to still be able to compare the performance of each item.