How to use 2 values within a stacked bar chart with a legend

[o59393]

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.

legend_2values.pbix

Thanks

Thanks.

[VahidDM]

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!! 

LinkedIn | Twitter | Blog | YouTube 

[VahidDM]

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

[o59393]

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. 

[o59393]

Hi @VahidDM 

Any idea how to get this?

Thanks.

[v-yilong-msft · Accepted 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.