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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

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!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!