Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |