Forum Discussion
Plot line graph without showing last month value
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?
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.
1 Reply
- bhanu_gautam
Super User
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.