Filter line chart without changing data

[wingsted93]

I have made a line chart to show active users over time. The values stems from a measure which is summing up the number of registrations minus the number of cancellations:

running total of active users =

CALCULATE(

    [Active users],

    FILTER(

        ALLSELECTED('Kalender'[Date]),

        ISONORAFTER('Kalender'[Date], MAX(Kalender[Date]), DESC)

    )

)

The 'Active users' measure is simply adding the number of regristrations and subtracting the number of cancellations. And the values i use in my line chart is, as the name implies, a running total of that number. 

My line chart is working and showing data on a monthly basis. However, I want to only show data for 6 months back. A simple filter on the chart will change the values. I need a way to filter the X axis without changing data. 

[Pragati11]

Hi @wingsted93 ,

Click on your line chart and got to visual level filters and apply filter on the column that is used on the x-axis.

Consider the following visual where I have got SALES by MONTH-YEAR:

Now suppose if I just want data to be shown for last 6 months, then apply visual level filter on Date column using Relative Filtering option:

Thanks,

Pragati

[wingsted93]

Hi @Pragati11 ,

I have aready tried that, but the values are only true if the calculations are made on the entire dataset, and when i filter the way you propose, i get wrong values on the line chart, as it calculates the difference in user registrations vs user cancellations. I need a way to filter without the measure "knowing" about it.

[Pragati11 · Accepted solution]

Hi @wingsted93 ,

In your measure, replace ALLSELECTED with ALL in that case and check if that works.

Thanks,

Pragati