Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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?
Solved! Go to Solution.
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
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
@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...
User | Count |
---|---|
121 | |
72 | |
71 | |
57 | |
50 |
User | Count |
---|---|
167 | |
83 | |
68 | |
65 | |
55 |