Forum Discussion
Upper an Lower Limits changing the date range on my graph
v-lionel-msft Can confirm, it was the date hierarchy I added in. I brought the date field as the actual date (not hierarchy) and it fixed the issue.
Community SupportHi Anonymous ,
Maybe the ALL () function removed the filters. But, when I did the test, nothing you described happened.
"In Edit Queries I limited the data load to only allow the past 18 months of data to be loaded in."
How did you do it ?
I did it like this:
Add a custom filter.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-lionel-msft The ALL function should only remove the filters on the visual/page/report levels not the data load level, since the data load filter removes all other months except the desired rolling 18 months. That is my understanding of the ALL function, if that is correct, then any measure created should only take into account the dates that are allowed in by the date filter in Edit Queries.
As far as my filter I did the previous 17 months or this month as my date filters.
How did you do your date filter? I need this to be dynamic if at all possible since this will be updated monthly and I do not want to have to manually change filters for my client.
Thank you.