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 tried your measure in the test file. The measure is working (see table on the right side. For December there is "1".

But the colors in the chart are not changing. Can you see what is wrong?

 

Here is the Link to the file.

 

https://www.dropbox.com/s/lg8avqqabjahyrd/Test.pbix?dl=0

 

The check for higher than today is ok. Maybe i can change it to Max-Date - 2 because we only have data for 2 more months than the fixed data.

  • MFelix's avatar
    MFelix
    Super User
    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

      Thanks for your Help. Its working 🙂