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

Reply
TheKnall
Frequent Visitor

Formating Function & Conditional Formating in a table

Hi Guys

I have a case where we we are working with messures and formats in a table.

When I use the Format function on a messure to change the formating, I see that the messure is changes to format Text.  When the format on a messure is text, conditional formating does not work in a Table / Matrix.

I have added a snapshot that shows this.

Is it not possible to use conditional formating on messures that has been formated with (Format function?Capture.PNG

Or is there other ways to shorten numbers that can be used with conditional formating.? 
Example: 1000000 -> 1 M

Thanks for the input

Best Regards
TheKnall



1 REPLY 1
v-sihou-msft
Microsoft Employee
Microsoft Employee

@TheKnall

 

In Power BI, once you use Format() function, the data field will be converted into "Text". However, the conditional formatting should be based on a numeric field. And if you change the data type, the format from Format() function will be disable. So in this scenario, I suggest you try build-in format for your data field.

 

777.PNG

 

Regards,

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.