Notifications
Clear all
General Excel Questions & Answers
3
Posts
2
Users
0
Reactions
240
Views
Topic starter
I have a power BI dashboard for training records, i have a matrix (not table) which contains names, certification name and expiry dates.
Where a cell in the matrix contains a date which is in the past (expired certification date) i would like this cell to have a red background.
Attached is a snip of the matrix and also my raw data excel
Posted : 18/05/2022 7:41 am
Hi Stuart,
Can you supply your PBIX file?
regards
Phil
Posted : 18/05/2022 7:26 pm
Hi Stuart,
You can write a measure like this
CF Expired Cert = IF(MIN('Data'[Expiry Date]) < TODAY(), "RGB(240,0,0)")
Then set the Background CF rule to use that Field value (measure)
Download my sample PBIX file
Regards
Phil
Posted : 18/05/2022 8:18 pm
