Forum Discussion

Wedding55's avatar
Wedding55
Helper II
5 years ago
Solved

Different Colors Datesbetween Measure

Hello,   i have four measures to calculate the different financial years. The measures are the same, only the time horizon is different.   Days 20/21 = CALCULATE(SUM('Process Data'[Tage]), DATES...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi Wedding55 ,

     

    My mistake since you are using months (that aggregate more than one date) you need to use the MAX instead of a selectedvalue:

     

    Condittional Formatting = IF(MAX(Tabelle[Date]) >= TODAY();1;0)

     

Wedding55's avatar
Wedding55
Helper II
5 years ago

Hi MFelix ,

 

i want to highlight automatically the last two month in the bars (see Screenshot).

 

 

Thanks in advance.

MFelix's avatar
MFelix
Super User
5 years ago

Hi Wedding55 ,

 

Don't know how you have your model setup in terms of dates and I assume you want to check if the date is higher than today then is forecast. Add the following code:

 

Condittional formatting = IF(SELECTEDVALUE('Table'[Date]) >= TODAY(); 1 ;0)

 Now just setup the condittional formatting on the bar part: