Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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 |
Solved! Go to Solution.
There is no screenshot. Have you tried NOT adding the category to the chart fields?
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.
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.
There is no screenshot. Have you tried NOT adding the category to the chart fields?
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
114 | |
94 | |
90 | |
35 | |
35 |
User | Count |
---|---|
153 | |
99 | |
82 | |
63 | |
54 |