topic Re: Cannot add measure to y axis in stacked bar chart in DAX Commands and Tips

Cannot add measure to y axis in stacked bar chart

Anonymous — Fri, 30 Dec 2022 13:53:12 GMT

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.

Re: Cannot add measure to y axis in stacked bar chart

ppm1 — Fri, 30 Dec 2022 14:11:38 GMT

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

Pat

Re: Cannot add measure to y axis in stacked bar chart

Anonymous — Fri, 30 Dec 2022 14:35:16 GMT

Many thanks, that worked out fine! 🙂