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
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
Employee
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
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.