Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |