Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Rita_Vaz
Frequent Visitor

Dynamic Formatting not working properly

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:

 

Rita_Vaz_1-1726738025433.png

 

Has anyone had the same issue? 

 

Thank you

 

4 REPLIES 4
BeaBF
Super User
Super User

@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

Hello, 

 

Thank you for your fast response!

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

 

Rita_Vaz_0-1726740500831.png

 

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

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

Rita_Vaz_0-1726756594781.png

 

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.