Forum Discussion
Conditional Formatting - User filter and the conditional formatting doesn't change for that range
Hi all... I may have asked this previously. Not sure if anyone have a solution or method around this. Thank you all for your help again.
Replicating conditional format in excel to PBI. For example, Site 6 is red as when conditional formatting for overall list but when let say user select just single site the formatting to remain static like Excel. Understood Excel not exactly filtering and hiding those row. Is there such work around in PBI?
PBI
EXCEL
Tevon713 , I think you need to use a color measure for that, You have to write all such conditions in a measure and return the color name.
And use that measure in conditional formatting using the field value option
example
Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) < date(2022,04,10) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .75 , "Amber" ,
"Red "
) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)
)Switch( True() ,
[Percent] =1 , "Green"
[percent] <.75 , "red",
[percent] <.99 , "Yellow"
)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
2 Replies
Tevon713 , I think you need to use a color measure for that, You have to write all such conditions in a measure and return the color name.
And use that measure in conditional formatting using the field value option
example
Color Date = if(FIRSTNONBLANK('Date'[Date],TODAY()) < date(2022,04,10) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .75 , "Amber" ,
"Red "
) ,
Switch(true(),
[SLA] = 1 , "Green" ,
[SLA] >= .5 , "Amber" ,
"Red "
)
)Switch( True() ,
[Percent] =1 , "Green"
[percent] <.75 , "red",
[percent] <.99 , "Yellow"
)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/1682539Thanks amitchandak. Figure need to write a measure probably be only solution to this.
