Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Changes in format string are not applied until I actually change the measure

This has been happening for a long time to me, but searching around I did not find an issue to vote, so here is it. 

Is quite simple, I have a measure and I want to change the format string (either applying a custom format string from the report view, or change the number of decimals). Well, it does not apply the changes. It does not unless I make some change to the measure, like adding a new empty line or similar. Then the changes are applied. 


Sometimes I do forget about that, so I fell for that while writting my latest post


please fix it! 

Community Support
Community Support

Hi, @AgulloBernat 


When you customize the formatting of the measure in the formatting pane at the top bar, you need to press Enter to confirm otherwise it will not take effect. You can format in the top bar or format in the model tab.






Please read the following documents and post about formatting for more information.

FORMAT function

Use custom format strings in Power BI Desktop

Kton unit of measurement



Hope this helps.


Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Super User
Super User

@AgulloBernat Right, you are hitting an issue with the optimization Power BI does to make things faster. Essentially, it's caching results so that it doesn't have to recalculate a bunch of stuff it already "knows". You changing the format doesn't nudge Power BI into thinking it has to recaculate anything. One could think of it as a bug and that changing a format should force a recalculation. 

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

May 2023 update

Power BI May 2023 Update

Find out more about the May 2023 update.

Submit your Data Story

Data Stories Gallery

Share your Data Story with the Community in the Data Stories Gallery.

Top Solution Authors