Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Proofinity

New/existing Measures: Format could not be changed to 'Text'

Submitted by on ‎03-07-2024 09:30 AM

Dear Power BI community,

 

unfortunatelly I'm not able to change my measure formats to 'Text' in multible semantic models. This issue occurs for new and existing explicit measures in Power BI Desktop and Tabular Editor 2. Without this functionality I'm not able to apply conditional formating logic or use SVG DAX measures.

Power BI Desktop (MS Store) - Version: 2.126.1261.0 64-bit (Februar 2024)

If I try to change measure format to 'Text' in Power BI Desktop it falls back to default format 'General'.

 

Proofinity_1-1709832294254.gif


Tabular Editor 2 - Version: 2.22.0

Format 'Text' is not available via dropdown menu in section Basic/Format String/Format.

Proofinity_0-1709832142031.png

 

Is this a bug?

 

Thanks for helping

 

Greetings Christian

Status: Investigating
See more ideas labeled with:
5 Comments (5 New)
Comments
Anonymous
Not applicable
‎03-08-2024 12:24 AM

Hi @Proofinity ,

 

I can't reproduce your problem, I created a measure="This is text", as per your sample.
Format is still the text option and it works fine for me.
I see you mentioned that you are using the MS store version, would downloading the latest version from the official download link solve your problem?

Download Power BI Desktop from Official Microsoft Download Center

 

Best regards.
Community Support Team_Caitlyn

 

Proofinity
Regular Visitor
‎03-08-2024 02:08 AM

Hi Community Support Team,

Thanks for you quick response. I've deinstalled my MS Store version and installed the version from Official Microsoft Download Center. Both versions seems to have same version numbers: 2.126.1261.0

Unfortunatelly the experience is still the same, format change not possible. Also checked the posibility in model view in Power BI Desktop.

What else could I try? 🤔

Proofinity
Regular Visitor
‎05-06-2024 05:14 AM

Hello Fabric Community,

I wanted to share an update regarding an issue I recently encountered while working with new measures in Power BI Desktop. After a detailed discussion with Microsoft Support, we were able to pinpoint a general bug affecting the creation and formatting of new measures.

Microsoft has acknowledged this problem and is currently working on a fix. We can expect a patch to be released in early August. Given this resolution and the expected update, I'll be closing the related support ticket.

If you're experiencing similar issues, please be on the lookout for the upcoming fix. Feel free to reach out if you have any questions or need further details on the matter.

Thank you for your attention, and let's keep our systems running smoothly!

Best regards,

Christian

Chen_Zitok
Frequent Visitor
‎09-09-2024 12:08 AM

Hi, is this issue resolved by Microsoft? i am currently encountering the exact same issue where text value is not available on formatting a measure. 

Chen_Zitok_0-1725865677724.png

 

Proofinity
Regular Visitor
‎09-16-2024 12:19 AM

Hi Chen,

Yes, this issue has been resolved by Microsoft. I encountered the same problem where the text format option was not available when formatting a measure. The solution was provided under Tracking ID #2403140050001781 and was implemented in early August.

May I ask if the measure was created in the semantic model or directly in the thin report? There are still some bugs in thin reports, where any new measure created via Power BI Desktop is initially formatted as a decimal number. This format can only be changed afterward. If you're still experiencing this issue, I recommend reaching out to Microsoft for further assistance.

Best regards, Christian

Idea Statuses