Percentage on Value Points

[KHSDM]

I have a stacked bar chart with the value labels enabled... but instead of the actual value, I want it to show the percentage. How can I do it?

[vinieme12]

Use Dual()

=Dual(Num(sum(Amount)/sum(Total Amount),'#,##0.00%') ,  sum(Amount) )

in Number formatting choose "Measure expression"

[KHSDM]

Use this in the measure expression? I tried, but cannot get it.

[vinieme12]

please post the expression you used

[KHSDM]

dual(Num(Count(distinct [ID])/Count(distinct TOTAL [ID]), '#,##0%'), count(distinct [ID]))

[vinieme12 · Accepted solution]

Use the Expression Modifiers instead

then change the below Option to "Relative"

[Andrea_Spinetti · Accepted solution]

Hello @KHSDM, another option is to add the % expression in the tooltips so when you over the stacked bar you will get the % of that bar like in the screenshot attached. 

In the chart:

- Go to Appearance>Tooltip.

- Untoggle the selector and set it to "Custom".

- Set in exrpession: Sum(UnitID) / Sum(TOTAL<[YearMonth]> UnitID)

- Set the format as "number" and choose the % format.

You can check the attached sample App 😊