Forum Discussion
Matrix table conditional formatting for a value field across two columns
I have this matrix table that shows the clock-in time of two employees -
Rows are dates and columns are the two employees. Values are the earliest times our systems detect their key-card swipes every day at the entrance door.
I want to use conditional formatting to highlight in red and green whichever one came in later than the other. So if employee A was late compared to employee B, A gets highlighted in Red and B gets highlighted in Green. Is there a way to do this?
Also if there is a way I can plot this in a line chart comparing the clock in times of the two employees over two different lines, that would be even better but so far I haven't been able to figure that one out either.
Thank you.
pborah , Create a measure like
Assume you have time to measure
if( [Time] = calculate(Minx(Values(Table[Employee]) , [Time]) , removefilters(Table[Employee]) ), "Red", "Black")
Use this in conditional formatting using the field value option
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
1 Reply
- amitchandakSuper User
pborah , Create a measure like
Assume you have time to measure
if( [Time] = calculate(Minx(Values(Table[Employee]) , [Time]) , removefilters(Table[Employee]) ), "Red", "Black")
Use this in conditional formatting using the field value option
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