powerbidaxreportpowerbi-desktopmeasure

Power BI table conditional formatting Based on another Column


I Have these data

StartDate   ,EndDate
03/01/2022, 06/01/2022
09/01/2022, 24/01/2022
20/01/2022, 27/01/2022
10/01/2022,22/01/2022
03/01/2022, 17/01/2022
28/01/2022, 20/01/2022
22/01/2022, 18/01/2022
28/01/2022, 05/01/2022
06/01/2022, 30/01/2022
10/01/2022, 18/01/2022
20/01/2022, 14/01/2022
12/01/2022, 11/01/2022
23/01/2022, 01/01/2022
09/01/2022, 06/01/2022

I want to format the Endate column as follows

IF StartDate > EndDate THEN Blue else green

Expected output enter image description here


Solution

  • Create a measure:

    Measure = IF(MAX(Table1[StartDate]) > MAX(Table1[EndDate]),1)
    

    Go to cell elements for End Date

    enter image description here

    Complete as follows:

    enter image description here

    enter image description here