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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
peterg0417
Helper II
Helper II

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors