Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
I am looking for some help with conditional formatting; i have created a training matrix that requires the status column to be orange if the training completed date has been completed and the re-audit date is blank, and if both the training completed date and Re-audit date is populated then the status should turn green.
This is how my columns look in the matrix table:
Thank you
Solved! Go to Solution.
Hi @Anonymous ,
try the following measure for formatting.
CF =
IF (
MIN ( 'Training Records'[DateTrainingCompleted] ) <> BLANK ()
&& MIN ( 'Audit Record'[Re Audit Date] ) = BLANK (),
"#E66C37",
IF (
MIN ( 'Training Records'[DateTrainingCompleted] ) <> BLANK ()
&& MIN ( 'Audit Record'[Re Audit Date] ) <> BLANK (),
"#00FF00",
BLANK ()
)
)
Hi @Anonymous ,
can you provide an example PBIX?
Hi @mwegener,
Please find an example pbix file: https://1drv.ms/u/s!AqpscUO4vhcRkgmpWKu5Wt-ET72b?e=zVyx33
Thank you
Hi @Anonymous ,
try the following measure for formatting.
CF =
IF (
MIN ( 'Training Records'[DateTrainingCompleted] ) <> BLANK ()
&& MIN ( 'Audit Record'[Re Audit Date] ) = BLANK (),
"#E66C37",
IF (
MIN ( 'Training Records'[DateTrainingCompleted] ) <> BLANK ()
&& MIN ( 'Audit Record'[Re Audit Date] ) <> BLANK (),
"#00FF00",
BLANK ()
)
)
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |