Forum Discussion

Ptolemaida's avatar
Ptolemaida
Frequent Visitor
2 years ago
Solved

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 fi...
Need Help
  • bhanu_gautam's avatar
    bhanu_gautam
    2 years ago

    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.

bhanu_gautam's avatar
bhanu_gautam
Icon for Super User rankSuper User
2 years ago

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.