Cannot add measure to y axis in stacked bar chart

[Anonymous]

Hi!

Do anyone know why I can't add measure "Kund Belopp = FORMAT(SUM(Orderdata[KundTotalRad]), "#,0")" to the Y axis in a stacked bar chart? It can only be added under tooltips.

The original field "Orderdata[KundTotalRad]" as well as measure "Kund Belopp = SUM(Orderdata[KundTotalRad])" both can be added under the Y axis in my chart without any problems.

[Anonymous]

Many thanks, that worked out fine! 🙂

[ppm1 · Accepted solution]

FORMAT returns text. Just create your SUM measure only, and then format it with the options in the ribbon.

Pat