Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Conditional Format Dates in a column based on Date in a previous column

Hello,    Firstly I am very new to PowerBI. I have been searching for a solution the following and cannot find anything, I am wondering if it is even possible?   Conditional Format Dates in a col...
Need Help
  • dax's avatar
    dax
    7 years ago

    Hi JTurv,

    You could try below suggestions:

    My data sample

    id t1 t2
    1 1/1/2018 1/1/2019
    2 5/1/2019 3/2/2019
    3 6/1/2019 1/5/2019
    4 4/5/2019 8/10/2019
    5 6/15/2019 7/15/2019
    6 5/18/2019 5/18/2019

    Then I create a measure for conditional format

    Measure 2 = if(MIN(comparetime[t2])>=MIN(comparetime[t1]), "#d6b3f2","#f4f7c3")

    Set confidition format on ID like below

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

dax's avatar
dax
Icon for Community Support rankCommunity Support
7 years ago

Hi JTurv,

You could try below suggestions:

My data sample

id t1 t2
1 1/1/2018 1/1/2019
2 5/1/2019 3/2/2019
3 6/1/2019 1/5/2019
4 4/5/2019 8/10/2019
5 6/15/2019 7/15/2019
6 5/18/2019 5/18/2019

Then I create a measure for conditional format

Measure 2 = if(MIN(comparetime[t2])>=MIN(comparetime[t1]), "#d6b3f2","#f4f7c3")

Set confidition format on ID like below

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks alot for this, exactly what I needed. 

     

    The only issue is I have to create a new measure to check each month against last month, I imagine it may be too complicated to create a single measure that could be applied to all date columns that would always check this months date against last months date?

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      dax Thank you for your help previously. 

       

      Would there be any way to manipulate the code so that it checks each month against it's previous month in one measure? 

      This would negate having to make new measures to compare each month. 

       

      I have gone a slightly different route by having all my data in Matrix table

       

       

      My columns are essentially data capture dates (once a month), ordered by a sort order in the DataDateOrder_Lookup table. The values are the dates captured on those data dates. 

       

      What I'm trying to achieve is assess the value (Date) in each column (DataDate) and flag red if the date is greater that the previous month.