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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
petesuen
Frequent Visitor

Measure formatting changed automatically

Hi all

 

I am having this problem with PowerBI where whenever i change the formula for a measure, it defaults it's number format back to "General". I had changed it to 'Custom' (specifically "#,##0") but every time I make a tweak to the measure the format is lost!

 

Anyone else have the same issue, or a solution? 

 

Thanks!

Peter

1 ACCEPTED SOLUTION
v-diye-msft
Community Support
Community Support

Hi @petesuen 

 

After my research , I'm afraid it couldn't achieve in Power BI for now .when you add a new measure ,you need to change the

Format of it individually, and it will not inherit the format of parent measure.

For your requirement , you could post your new idea in Power BI ideas and make this feature coming sooner .

 

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

View solution in original post

3 REPLIES 3
v-diye-msft
Community Support
Community Support

Hi @petesuen 

 

After my research , I'm afraid it couldn't achieve in Power BI for now .when you add a new measure ,you need to change the

Format of it individually, and it will not inherit the format of parent measure.

For your requirement , you could post your new idea in Power BI ideas and make this feature coming sooner .

 

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

Thank you for your confirmation!

Greg_Deckler
Super User
Super User

I'll have to test that. Perhaps try the formatting technique here: https://community.powerbi.com/t5/Quick-Measures-Gallery/Chelsie-Eiden-s-Duration/td-p/793639

 

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


@ 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

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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