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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Cfarinha
Frequent Visitor

Conditional Formatting and the Letter E

This is either a bug or serves some purpose that I'd like to understand.

Go apply conditional formatting to a matrix table. In Minimum or Maximum try to enter a letter A-Z instead of a number. 

None work...except the letter E. 

 

Anyone know why?

1 ACCEPTED SOLUTION
MattAllington
Community Champion
Community Champion

Sounds like letter E is a bug. It is not supposed to work on letters.  It you can create custom formulas now, so that may work. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

View solution in original post

2 REPLIES 2
MattAllington
Community Champion
Community Champion

Sounds like letter E is a bug. It is not supposed to work on letters.  It you can create custom formulas now, so that may work. 



* Matt is an 8 times Microsoft MVP (Power BI) and author of the Power BI Book Supercharge Power BI.
I will not give you bad advice, even if you unknowingly ask for it.

Stumbled on this while trying to trick PBI into formatting a column of letter grades (A, B, and C). Felt like I was almost there, but hit a dead end. 

 

Looks like you can get it to enable the conditional formatting options on text values by combining the measure with its numeric value via SWITCH() and then creating a toggle table for the SWITCH().

 

Beyond that though, no luck.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.