Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm trying to create dynamic dollar value labels, which is working in a standard bar chart and KPIs, but as soon as I add a second dimension to have a stacked bar chart, it isn't taking into account the first half of the dual expression:
Dual(Num(sum([TCV])/Pow(10,3*Div(Log10(sum([TCV])),3)),'$#,##0.0')&' '&Pick(Div(Log10(sum([TCV])),3),'k','M','B','T'),sum([TCV]))
The value is still ending in k, M, or B as appropriate, but the single decimal point and the $ both disappear when the second dimension is added. I do have the number formatting set as 'Measure Expression'. Snapshot attached showing how the numbers kind of work, but I really need the dollar signs too.
hi @nicanova
I have the same issue, seems like the Dual function + Measure expression as Number formatting doesn't work with 2 dimensional stacked bar charts.
Have you got a solution?
Thank you and best regards,
KC
@kanhomcake no solution still, for the time being, we've just accepted it as a limitation. If you figure something out, please let me know!
Nicole