Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hi all
I have a stacked bar chart with a legend and I'd like to have next to the end of each graph bar the HC result (see red arrow in the image). For that, it would be required to have 2 values within the x-axis.
I know this is not possible because of the legend that doesnt allow 2 values. But is there any way to have it with a measure or special calculation ?
I attach the pbix.
Thanks
Thanks.
Solved! Go to Solution.
Hi @o59393 ,
I think you can use Clustered bar chart, but it can only allow you to put the below chart on the top.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If you like to show the Number of HC beside the Perent o fthe total, in the Data Lables of the visual formatting pane, slect the Value and set that to Sum of HC like this:
The output:
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
Hi @o59393
Do you want to show 2 values (numbers) in each bar? like %56 - 218?
Can you describe the output with more details please?
Regards,
Vahid
Hi @VahidDM
Thanks for your reply. Let me explain better and attach the pbix corrected.
Click on the image to see at a better resolution:
Basically is to have the disctinct count of the column 'name' at the end of each graph bar. As an example, I manually added the numbers 60 and 34 values with Paint to better explain the desired outcome.
So intead of having 2 graphs, I would just like to have one.
Here is the pbix. legend_2values.pbix
Thanks a lot.
Hi @o59393 ,
I think you can use Clustered bar chart, but it can only allow you to put the below chart on the top.
Best Regards
Yilong Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
115 | |
112 | |
105 | |
95 | |
58 |
User | Count |
---|---|
174 | |
147 | |
136 | |
102 | |
82 |