Plot line graph without showing last month value

[Ptolemaida]

I am plotting sales data from Current Year, Year-1 and Year-2 on a line graph

Year is in the legend, as to have 3 line graphs in one single chart.

Problem is that the current month is not yet finished, resulting in a false data point on the current year's graph.

I cannot unselect "September" since it will then not show September value for all the years. 

How can i not show September of Current year, while still show it for Year-1 and Year-2?

[bhanu_gautam · Accepted solution]

@Ptolemaida , Try using below method

Create a DAX Measure to Identify the Current Month:

CurrentMonth = MONTH(TODAY())

Create a DAX Measure for Sales Data Excluding Current Month for Current Year:
SalesExcludingCurrentMonth =
IF(
YEAR([Date]) = YEAR(TODAY()) && MONTH([Date]) = MONTH(TODAY()),
BLANK(),
[Sales]
)

Use the New Measure in Your Line Graph:

Replace the original sales measure with SalesExcludingCurrentMonth in your line graph.
Ensure the Legend and Axis are Correct:

Make sure the Year is in the legend and the Date (or Month) is on the axis.