Forum Discussion

wingsted93's avatar
wingsted93
Frequent Visitor
5 years ago
Solved

Filter line chart without changing data

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. 

Need Help
  • Pragati11's avatar
    Pragati11
    5 years ago

    Hi wingsted93 ,

     

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

     

    Thanks,

    Pragati

3 Replies

  • Pragati11's avatar
    Pragati11
    Super User
    5 years ago

    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's avatar
      wingsted93
      Frequent Visitor
      5 years ago

      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's avatar
        Pragati11
        Super User
        5 years ago

        Hi wingsted93 ,

         

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

         

        Thanks,

        Pragati