Forum Discussion
Helper VConditional 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.
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.
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?
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
2 Replies
- amitchandak
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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3 
vickydThe 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
