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)

     

MFelix's avatar
MFelix
Super User
5 years ago

Hi Wedding55 ,

 

Not really understanding what is the colour change that you need to have. What is the information you want to highlight, is it part of one of the lines is it the bar chart?

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: