Show data from today() and mark today() on graph

[giorgi_lommidd]

Hi, 
On the chart i need to display "ExmForTest" and "RevenueForecastM"  from today() not (as it is displayed) for whole current year. I also need to mark today() day on the graph somehowe, for example some vertical line on toyday() day  USING DAX. At the very end you can see the link of corresponding (.pbix) document.



https://drive.google.com/file/d/1gUnzTymn3DK2ip3DVXMvmio34yPhy_VF/view?usp=sharing

[sturlaws · Accepted solution]

I must say, well done on the dax code for the forecasting measure, that is an impressive piece of DAX.

In order to get the measures to start from today, you can change this part

// ************************************************MONTH******************************************************************
       IF ( AND ( ISINSCOPE ( DateHelper[Date].[Month] ); NOT ( ISINSCOPE (  DateHelper[Date].[Day] ) ) );

to this

If(ISINSCOPE(DateHelper[Date].[Month]) && NOT(ISINSCOPE(DateHelper[Date].[Day] )) && SELECTEDVALUE(DateHelper[Date].[MonthNo])>=MONTH(TODAY());

When it comes to vertical lines, I am afraid that is not possible. There are some workarounds. It is possible to create line as a static shape. Or you can add markers as outlined here https://prathy.com/2018/05/adding-a-vertical-line-or-marker-to-a-chart-in-power-bi/. Neither of these options are optimal in my opinion. You can vote for ideas for improving, and perhaps Microsoft will implement it some day
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8083068-vertical-current-day-line...
https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19550122-vertical-reference-lines...