Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Use the Expression Modifiers instead
then change the below Option to "Relative"
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 😊
Use Dual()
=Dual(Num(sum(Amount)/sum(Total Amount),'#,##0.00%') , sum(Amount) )
in Number formatting choose "Measure expression"
Use this in the measure expression? I tried, but cannot get it.
please post the expression you used
dual(Num(Count(distinct [ID])/Count(distinct TOTAL [ID]), '#,##0%'), count(distinct [ID]))
Use the Expression Modifiers instead
then change the below Option to "Relative"
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 😊