topic Re: Dynamic Formatting not working properly in DAX Commands and Tips

Dynamic Formatting not working properly

Rita_Vaz — Thu, 19 Sep 2024 09:31:20 GMT

Hello everyone,

I am having some issues with the dynamic formatting of a measure. I am using this simple code in the format:

SWITCH (
    TRUE (),
    SELECTEDMEASURE () >= 0 && SELECTEDMEASURE () < 1000,FORMAT ( SELECTEDMEASURE (), "#0 " ),
    SELECTEDMEASURE () >= 1000 && SELECTEDMEASURE () < 1000000, FORMAT ( SELECTEDMEASURE (), " #,##0,.0 k" ),
    SELECTEDMEASURE () >= 1000000 && SELECTEDMEASURE () < 1000000000,FORMAT ( SELECTEDMEASURE (),"#,##0,,.0 M" ),
    SELECTEDMEASURE () >= 1000000000,FORMAT ( SELECTEDMEASURE (), "#,##0,,,.0 bn")
)

I am using this measure in a bar chart with a category in the y-axis and for some categories the data label is misformatted, see image bellow:

Has anyone had the same issue?

Thank you

Re: Dynamic Formatting not working properly

BeaBF — Thu, 19 Sep 2024 09:55:07 GMT

Rita_Vaz Try with:

SWITCH (
TRUE (),
SELECTEDMEASURE () >= 0 && SELECTEDMEASURE () < 1000, FORMAT ( SELECTEDMEASURE (), "#0" ),
SELECTEDMEASURE () >= 1000 && SELECTEDMEASURE () < 1000000, FORMAT ( SELECTEDMEASURE (), "#,##0,.0 K" ),
SELECTEDMEASURE () >= 1000000 && SELECTEDMEASURE () < 1000000000, FORMAT ( SELECTEDMEASURE (), "#,##0,,.0 M" ),
SELECTEDMEASURE () >= 1000000000 && SELECTEDMEASURE () < 1000000000000, FORMAT ( SELECTEDMEASURE (), "#,##0,,,.0 Bn" ),
SELECTEDMEASURE () >= 1000000000000, FORMAT ( SELECTEDMEASURE (), "#,##0,,,.0 Tn" )
)

BBF

Re: Dynamic Formatting not working properly

Rita_Vaz — Thu, 19 Sep 2024 10:09:22 GMT

Hello,

Thank you for your fast response!

I tried the code you sent but the issue still remains 😞

Re: Dynamic Formatting not working properly

BeaBF — Thu, 19 Sep 2024 12:09:19 GMT

Rita_Vaz can you share the pbix file or the sample data under the visual?

Re: Dynamic Formatting not working properly

Rita_Vaz — Thu, 19 Sep 2024 14:36:43 GMT

Hello, I cannot share the pbix file but I tried also with the contoso dataset but I encountered the same issue: