Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
Anonymous
Not applicable

Avoid multiple category name in 100% stack bar chart

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

 

categoryInstancecompletednot completed
ABCIS11000
ABCIS28020
ABCIS35050
ABCIS42080

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

rajeshw_0-1627290248081.png

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.

 

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. 

 

v-rzhou-msft
Community Support
Community Support

Hi @Anonymous 

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

Your visual should looks like as below.

1.png

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

2.png

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

3.png

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
Super User
Super User

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

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.