TAbular editor - for overwriting data labels - number formatting

[bsz412]

Hi, 

I am creating dynamic labels to my charts in Tabular editor. I noticed that 

VAR totalsales =
FORMAT( ( [Total Sellout] / 1000) , "#,##0.#\K;") this expression returns negative values with 2 minus signs: 

 If I modify it and create whole numbers, this is not happening

FORMAT( ( [Total Sellout] / 1000) , "#,##0\K;")

How could I fix that?

thank you!

[v-henryk-mstf]

Hi @bsz412 ,

Combine this with the custom naming convention given in the documentation for adjustment, or refer to a similar video presentation.

Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs

(144) CUSTOM FORMAT STRINGS in Power BI | Making sense of ##0,.0 K - YouTube

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.