Forum Discussion

mws5872's avatar
mws5872
Helper II
5 years ago
Solved

Conditional line styling for line chart

I have actual and forecast numbers that I am working with and each week and over time actuals will replace the forecast values for the line graph. I want it to be the same line where actuals should b...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    Hi mws5872 ,

     

    On this case you need to add two measures in orde to have two different lines and then make the individual value for each one.

     

    Something similar to:

    Actuals = IF(Max(Table[Date])<= Today(), sum('Table'[Actual]))

Forecast measure = IF(Max('Table'[Date])= Today(),sum('Table'[Actual]),  IF(Max('Table'[Date])> Today(),sum('Table'[Forecast])))

     

    Be aware of the forecast line that you need to add on the current date the actuals values  this is for the lines to be linked otherwise they will appear with a break.

     

     

    Then just do a customized format of the shapes for each measure.

     

MFelix's avatar
MFelix
Super User
5 years ago

Hi mws5872 ,

 

On this case you need to add two measures in orde to have two different lines and then make the individual value for each one.

 

Something similar to:

Actuals = IF(Max(Table[Date])<= Today(), sum('Table'[Actual]))

Forecast measure = IF(Max('Table'[Date])= Today(),sum('Table'[Actual]),  IF(Max('Table'[Date])> Today(),sum('Table'[Forecast])))

 

Be aware of the forecast line that you need to add on the current date the actuals values  this is for the lines to be linked otherwise they will appear with a break.

 

 

Then just do a customized format of the shapes for each measure.