Forum Discussion

TiborTuboly's avatar
TiborTuboly
Frequent Visitor
7 years ago
Solved

How to differentiate past data and future data on a line chart

Hi All, I would like to create line charts with dates on the X-axis and values on the Y-axis. I should differentiate the future data and past data (e.g. when the values belong to a future date,...
Need Help
  • parry2k's avatar
    parry2k
    7 years ago

    TiborTuboly I guess you can achieve this by using couple of measures. Add following measures and put date on x-axis and these two measures on Y - Axis.

     

    Amount = IF( MAX( Table1[Date] ) <= TODAY(), SUM( Table1[Amount] ) )

Amount Future = IF( MAX( Table1[Date] ) >= TODAY(), SUM( Table1[Amount] ) )

    To show dotted line for future, go to format tab and under shapes, turn on customize series, and select "Amount Future" and change it to dashed.

     

     

     

    This is how output will look like

     

  • walterfjr's avatar
    walterfjr
    7 years ago

    Hi TiborTuboly,
    I created an example where basically in the modeling area I created a formula to check if the date is past or future:

     

    DataType = IF (Exemple [Date] <TODAY (), "Past", "Future")

     

    Later I put a line chart and put the DataType in Legend column, and in shapes> Customize series I formatted "Future" series as Dotted.

     

    Example

     

    Hope this helps

     

walterfjr's avatar
walterfjr
Icon for Advocate I rankAdvocate I
7 years ago

Hi TiborTuboly,
I created an example where basically in the modeling area I created a formula to check if the date is past or future:

 

DataType = IF (Exemple [Date] <TODAY (), "Past", "Future")

 

Later I put a line chart and put the DataType in Legend column, and in shapes> Customize series I formatted "Future" series as Dotted.

 

Example

 

Hope this helps