Line Chart

[M_SBS_6]

Hi, 

I have a line chart with future values. Is there anything I can do to change a colour of the line from blue to orange where the date is greater than today? 

X-axis : month_year

Y-axis : sum app_amt

[Anonymous · Accepted solution]

Hi @M_SBS_6 

If your line chart doesn't have a legend field, you can create a measure for the sum of future values. Just like below. Add it to Y-axis. You will have two Y-axis fields now. Then you can format their colors separately. 

Future Amt = IF(SELECTEDVALUE('Table'[Date])>=TODAY(),SUM('Table'[app_amt]))

Best Regards,
Jing
If this post helps, please Accept it as Solution to help other members find it. Appreciate your Kudos!