Forum Discussion
Conditional formatting help on count
Hi sameergupta60 ,
Please try this measure:
Measure = VAR _maxrcc = MAXX(SUMMARIZE('Table','Table'[Tower Name],"rcc",[RCC]),[rcc]) VAR _colour = IF([RCC]-7>[Block Works]&&[RCC]=_maxrcc,"Red","Green") RETURN _colourBest Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data
sameergupta60 , Not very clear. But you can create a color measure and use that in conditional formatting using field value option
Switch(True(),
[Total RCC] - [Block works] >[RCC] , "Red", "Green" )
You can also have default as blank
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
Dear Sir,
if my RCC is on the 25 floors then my block should be on 18 floors but in current progress it is on 7 floors so should be a highlighted red color in Block works.
