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 u...
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

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