Forum Discussion
Solved
Conditional formatting based on rules and colors
i Have following sample data-
Name
timestamp
Work Area
order picks
abc
10-Feb
A
2
abc
10-Feb
B
3
abc
10-Feb
A
2
abc
11-Feb
A
3
dec ...
learner03 , Create a measure like
color =
var _m1 = calculate(distinctcount(Table[Work Area]) )
var _m2 = calculate(distinctcount(Table[Work Area]), filter( Table,Table[Work Area] = "A") )
return
if(_m1 -_m2, "Red", "Blue")
Use in conditional formatting using field value option
Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.
https://dropmefiles.com/GAoVfyou can write measure like this
