How to change data label format in % Stacked Bar Chart?

[garimaa85]

I am trying to change the Data Label Format in th %Stacked Bar Chart. Currently it is showing as "%" and I want it to display "Actual Number" while retaining the chart type.

[v-yulgu-msft · Accepted solution]

Hi @garimaa85,

It is not possible to display "Actual Number" as data label while keep chart type with 100% stacked. As a workaround, to show "Actual Number" on chart, you can add the "Actual Number" field into "Tooltips" section of chart. When you hover over any bar of chart, it will show corresponding "Actual Number" per category.

Best regards,

Yuliana Gu