Showing % of stacked bar

[Anonymous]

I have a stacked bar chart that shows ticket counts where the light blue (in attached pic) are the SLA violations. I have the total count at the top of the bar (show totals) but would like to ... somehow, as a data label I guess, show the percent of the light blue of the stacked bar at the bottom of each bar. Is that doable? 

Thank you!

Rob

[v-shex-msft]

Hi @Anonymous,

You can change this visual to the 100% stacked bar chart and it will show the percent of value.

In addition, you can also create measure expressions to calculate the percent of the grand total. Then you could use them to replace raw visual value fields to switch the chart display the percent values.

If you are confused about the code formula, please share some dummy data here with expected results to help us clarify your requirement and test coding formulas.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[Syk · Accepted solution]

You can display the actual values by turning on the "Data Labels" in the visualization tab (see first screenshot as an example). If you need to show % of total you might want to use the 100% stacked bar chart (see second screenshot as example) or use a tooltip with the first option!