Forum Discussion
Conditional formatting help on count
Dear Team,
Need help with conditional formatting.
if my RCC is on max count then block work conditional formatting -7 with any red cell color
Example = 26-7 = 19 but the current status of Block work 7 so this cell has highlighted using conditional formatting.
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
10 Replies
Hi can you share a sample data set.
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-66e0afcb15f3Dear 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.
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
Dear Sir,
if my RCC counts on 8 floors then the block work count should be on 1 floor.
if is on 1 floor then it is green or red if it is not on 1 floor.
But if my RCC floor is on 5 floors then blockwork works have yet to start and need no color formatting that time.
Dear Team,
this solution work on the tower level summary.
BWNEWBICFzone = VAR _maxrcc = MAXX(SUMMARIZE('L1','L1'[Code33],"rcc",[RCCCount]),[rcc])VAR _colour = IF([RCCCount]-7>[BWcount]&&[RCCCount]=_maxrcc,"Red","Green") RETURN _colourbut when we add the same logic to the project summary it is not showing results properly.
if we see at the project level total of 13 the block work must be red but it is showing green.
Can please share logic for project level
Hi sameergupta60 ,
Would you please consider sharing a sample file for testing, that would be helpful, thanks in advance!
Best Regards,
Gao
Community Support Team
