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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
peterg0417
Helper III
Helper III

New feature feedback - Dynamic Measure Formatting

The new feature for April 2023 release has been a game changer. Finally we are able to add custom strings to our measures and not lose the number format, which means we can use them in bars, lines and column charts.
 
I've been going through all of my measures to apply my new format string and it's been 95% smooth for all but one scenario.
 
I know this is a preview feature so not all kinks have been ironed out but wanted to highlight this in the hopes of getting it addressed in a new update.
 
It seems to only be happening in the "Total labels" even though I have the formatting in that section set to "none" (like it's supposed to be). I'm also using "dimension parameters" as a Legend in this visual (to toggle between location, asset class, and division). I suspect that it's the parameter in conjunction with having a field in the X-Axis that is causing this issue.
peterg0417_0-1683128637041.png

 

 
My custom measure string:
 
SWITCH (
    TRUE (),
    SELECTEDMEASURE () < 1000, "$#,##0",
    SELECTEDMEASURE () < 1000000, "$#,##0,.0K",
    SELECTEDMEASURE() < 1000000000, "$#,##0,,.0M",
    "$#,##0,,,.0B"
)
 
 
If someone found a solution then please let me know, or if the dev team has any ideas on how to get this to work (or fix it in an update) I'd be very grateful.
 
Cheers!
2 REPLIES 2
lbendlin
Super User
Super User

You can raise an issue at https://issues.powerbi.com . If you have a Pro license you can consider raising a Pro ticket at https://powerbi.microsoft.com/en-us/support/pro/

Thank you. Didn't know this was an option.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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