Skip to main content
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

Not applicable

Dynamic Formatting for Thousands & Millions

Hi all,


I wonder if anyone can suggest a means of using the custom format capabilities of PowerBI to replicate what in Excel would look like this:


[>=1000000] #,##0.00,,"m";[<1000000] #,##0.0,"k";General


Essentially what I'm after is for when the number is in the millions for it to be formatted with two decimal places and have an 'm' appended to the number, when it's in the thousands, a single decimal place and a 'k' appended. I'm aware that I could create a measure using the SWITCH function to do this, but wonder if anyone has come up with a custom format that does the same thing?


Thanks in advance,



Helper II
Helper II

Power BI can now do this. It is called dynamic format strings

Create dynamic format strings for measures in Power BI Desktop - Power BI | Microsoft Learn

Regular Visitor

Screenshot 2023-08-11 182835.png

hi i am wondering if someone could helpme. i tried to change the format to currency and seted up with two decimal places. i got everything righ in other chart but not this multi-row card. I don't know why.


If these are measures, make sure it is set on the measure itself


I have set this and it seems to work for me



New Member


In the above screenshot, you can see I have selected the measure - "Total Revenue".

Under the format Tab, the format Is General.

---- Switch the format to Currency.

---- Also adjust the decimal points to two places.




Check the above screenshot. You can check the card which shows Monthly revenue and check the values as they add a "K" or "M" when required.



Helper II
Helper II

I am looking for a solution to this too if anyone knows of one?

Rather than writing it into a measure, I would like to do it using the dropdown option to select custom format like you do in Excel

Regular Visitor


I have also encountered the same issue and was wondering has anyone found a solution for this yet. Even when i set the 

[>=1000000] #,##0.00,,"m";[<1000000] #,##0.0,"k";General

in excel and import into PowerBi, it will clear this.  

Super User
Super User
Not applicable


Thanks for the reply - I think maybe you misunderstood the question slightly: I'm looking to use custom formatting in the Model view to do this rather than in a measure. The ultimate goal being that I can do a quick, non-destructive change to a number's format rather than having to go a write a measure everytime (as per the SWITCH suggestion in my original post). The RADACAD article is useful, but only really for date formats.


Custom format in Model viewCustom format in Model view





Helpful resources


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.


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