Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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:
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.
Solved! Go to Solution.
Hi @wingsted93 ,
In your measure, replace ALLSELECTED with ALL in that case and check if that works.
Thanks,
Pragati
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
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.
Hi @wingsted93 ,
In your measure, replace ALLSELECTED with ALL in that case and check if that works.
Thanks,
Pragati
User | Count |
---|---|
103 | |
90 | |
78 | |
72 | |
68 |
User | Count |
---|---|
108 | |
96 | |
95 | |
74 | |
71 |