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
vickyd
Helper V
Helper V

Conditional formatting not working anymore for non-measure fields

I am connecting from Power BI Desktop to an SSAS cube.

The conditional formatting pane is not providing aggregated value when I try to conditional format based on a regular text field. This used to work earlier but is not now and I don't know exactly why. 

 

Here's how I would expect it to show up. 

vickyd_0-1681174831536.png

However, here is what I get now when I try to select any value field (not a measure). I'd expect it to show me Count of Project as inthe screenshot above but it doesn't do that anymore for some reason. 

vickyd_1-1681174879552.png

 

We actually have an older PBI report that is connected to the exact same model and it works fine when published. However, when I download the same PBIX file and try to change it in PBI Desktop, it shows a blank value as shown above. 

 

Any idea what could be causing it? 

 

1 ACCEPTED SOLUTION
vickyd
Helper V
Helper V

The issue was because in the SSAS Model, the "Discourage Implicit Measures" option was set to to TRUE. This was causing the conditional formatting pane to now show the default COUNT option for non-numeric fields. 

 

Here's a link to a post that was indrectly referring to the same issue I was facing.

Solved: Tabular Editor - Calculation groups - Microsoft Power BI Community 

View solution in original post

2 REPLIES 2
vickyd
Helper V
Helper V

The issue was because in the SSAS Model, the "Discourage Implicit Measures" option was set to to TRUE. This was causing the conditional formatting pane to now show the default COUNT option for non-numeric fields. 

 

Here's a link to a post that was indrectly referring to the same issue I was facing.

Solved: Tabular Editor - Calculation groups - Microsoft Power BI Community 

amitchandak
Super User
Super User

@vickyd , Text conditional formatting will work on text measure. You have option in Feb for that

Learn Power BI- Feb 2023 Feature- Conditional formatting based on string fields: https://youtu.be/Fq0JneLDbGs

 

 

Or you can create a measure like and use that in conditional formatting using field value option

 

Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)

 

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.