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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
OlapOffice
Helper II
Helper II

Measure Format String Issues?

Is anyone experiencing any issues with Measure Format Strings. I noticed that all had disappeared from my project and went back to an historical version where the report showed the correct formatting but when opening through Tabular Editor the relevant format was not displayed. Is there a current known issue with Measure Format Strings through Tabular Editor? Currently on September 2021 Power BI Desktop.

6 REPLIES 6
parry2k
Super User
Super User

@OlapOffice Can you check another file and see if the format string is intact or it is something specific to this file?

 

Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

V-pazhen-msft
Community Support
Community Support

@OlapOffice 

Not sure what do you mean by Measure Format Strings. Please elaborate.

 

Reference (both works fine in my test)

Use custom format strings in Power BI Desktop - Power BI | Microsoft Docs

or

SELECTEDMEASUREFORMATSTRING function (DAX) - DAX | Microsoft Docs

 

 

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

They formats just disappeared on all measures for some reason. This is the image on the measure from Tabular Editor.

OlapOffice_0-1632828344519.png

 

parry2k
Super User
Super User

@OlapOffice I just opened a report that has calculation group and calculation items are using format string and it is intact, using Sep 2021 release.

 

Follow us on LinkedIn

 

Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would  Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

 

Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Thanks for the reply. As pre the original post, the Measure Format String is not present in an historical file either although it formats as required. I had not resaved this file. The later file is subsequently resaved and the formatting string and report formats are gone.

After resetting all the measure strings the same thing has happened again. This is getting a little frustrating. Maybe other users of Tabular Editor have experienced the same thing?

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

MayPowerBICarousel

Power BI Monthly Update - May 2024

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