Avoid multiple category name in 100% stack bar chart

[Anonymous]

Hi Team

We are unable to removed repeated category name on X axis. It is repeated for all the Instances. 

We want category needs to be shown only once in the first column (ABC shold appears once in of the 100% stackbar chart). Please find screesnshot for your reference.

table

category	Instance	completed	not completed
ABC	IS1	100	0
ABC	IS2	80	20
ABC	IS3	50	50
ABC	IS4	20	80

[Anonymous]

Thanks for the reply. There is no option for Concatenate in 100% percent stack bar chart. 

The requirement is to show only one category i.e. ABC against the instance i.e. IS5,IS6 etc. like the way we do stepped layout option for Matrix report.

[Anonymous]

Hi @Anonymous 

Currently Concatenate labels only support in X axis. Here I suggest you to use column chart instead of bar chart if you want to use this function.

Your demand is a good idea, while it is not supported to implement in Power BI currently.
You can vote up this idea for this function：Y-axis Categorical and Concatenation Option for bar charts

Or you can submit a new idea to improve the Power BI.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,

Rico Zhou

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

[Anonymous]

Hi @Anonymous 

I think you want to show ABC once in your hierachy level.

Your visual should looks like as below.

Firstly click "..." in the right above corner of the visual. Sort the visual by X aixs. Here is "category instance".

Turn off Concatenate labels in X axis in visual format. Result is as below.

Best Regards,

Rico Zhou

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

[lbendlin · Accepted solution]

There is no screenshot.  Have you tried NOT adding the category to the chart fields?