Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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...
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
74 | |
71 | |
39 | |
27 | |
27 |
User | Count |
---|---|
97 | |
97 | |
58 | |
45 | |
42 |