Forum Discussion

Shawry's avatar
Shawry
Helper I
2 years ago

Change line graph visual based on whether date is future dated

Hi,    I'm wondering if it's possible to format future dated data points differently? For example, if I was to plot the 'Planned Leave #' using a line graph - is it possible to display the forecast...
Need Help
fahadqadir3's avatar
fahadqadir3
Solution Supplier
2 years ago

Shawry You can create dotted line for future dates, please review the attached screenshot and pbix file. 

PastPlannedLeave = IF(MAX('Table'[Date]) <= TODAY(), MAX('Table'[Planned Leave #]), BLANK())

FuturePlannedLeave = IF(MAX('Table'[Date]) > TODAY(), MAX('Table'[Planned Leave #]), BLANK())
 
 

Planned Leaves.pbix

 

Hope it works.

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!