Disable the Y axis labels of not having values in Small multiple chart

[shoeb1359]

Hello Experts,

I have Clustered bar chart in which Category used as small multiples. It's giving all subcategory in Y axis even those not belongs to that Category. Is there anyway we can control it to show only respective Subcategries related to Category.

Or is there any other similar way or custom visual.

CategorySubCategoryProfit Category A A1 100 Category A A2 200 Category A A3 300 Category B B1 400 Category B B2 500 Category C C1 600

[Bibiano_Geraldo · Accepted solution]

Hi @shoeb1359 ,

You can achieve the desired result by downloading at app source this visual:  Clustered Bar Chart By Akvelon

Drag and drop your measures to look like this:

In format pane, expand the y-Axis, and Axis Range type choose Separate:

Your final result should look like this:

[shoeb1359]

Thanks a lot .

It was really helpfull.✌️

[Tahreem24]

@shoeb1359 Could you explain what would be the expected output?

[shoeb1359]

something like that, so basically those subcateries data are not in the main category it should not be visible.

[danextian]

Hi @shoeb1359 

As per testing, that really is the behaviour of small multiples even if the dimensions are from a related table. I suggest to raise this as an idea. https://ideas.fabric.microsoft.com/

[shoeb1359]

Is there any other way to achieve the required output?