Forum Discussion
Power BI Conditional Format
Hi Guys. Looking for some help on conditional formatting and counting of measure.
I have the following table:
In a matrix visual, I would like to conditional format just the row total based on the values of subcategory. Regardless of the total, if two thirds (2/3) of overall subcategories met the target, I would like to conditional format the row total as green. In the example below, Drill has 5 subcategories. Even though overall Drill category failed to meet the target, but because 3 out of 5 subcategories did meet the target, I would like to change it to green.
** Achieved = if( [Actual] >= ([Target] * 0.667), 1,BLANK())
Is there a way I could also count the number of rows that have achieved 1 for the measure.
So something along the lines of:
CALCULATE( COUNT(EQ Code), **Achieved = 1)
Is this what you are looking for?
https://1drv.ms/u/s!AiUZ0Ws7G26Rhhi5XjS05sJYeyNX?e=zcn3TL
3 Replies
Is this what you are looking for?
https://1drv.ms/u/s!AiUZ0Ws7G26Rhhi5XjS05sJYeyNX?e=zcn3TLazakir , Based on what I got, you can use measure based conditional formatting
example
Measure =
Switch(true(),
max(Table[status]) = "In production" , Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
) ,
max(Table[status]) = " Product completed" , Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)
)Learn Power BI Advance - PowerBI Abstract Thesis:
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
