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 been working on the problem for several hours. I have a data set with many dates that were automatically turned into date hierarchies as I would expect. When I create a table and drop the date hierarchy into it and then try to create a page filter on the same field, the page filter has no effect at all.
Solved! Go to Solution.
I just attempted the same on a blank PBIX and can't reproduce your issue. In the table visual, can you try setting your date field to just the date rather than having the expanded hierarchy?
Unfiltered:
Filtered:
Hi @lawsonbe,
There isn't enough info here to find an answer. Could you post a picture of what you're attempting and the result?
Here is a screen shot. The basic_date is the only thing in the table and it is what I am filtering on. As you can see, the page filter is having no effect. Oddly, when I started the desktop up a minute ago, the filter was effecting the table. When I tired to replicate the steps of filtering the table, it no longer worked.
I just attempted the same on a blank PBIX and can't reproduce your issue. In the table visual, can you try setting your date field to just the date rather than having the expanded hierarchy?
Unfiltered:
Filtered:
This has solved an issue I stuck with since yesterday. Seems that hierarchy isn't a good freind with filters
Your solution worked. I still wonder why the filter is not working on the hierarchy as it was.
https://www.dropbox.com/sh/u53iupxhfekny49/AADtI40U--Opz6UZBHW3GmB5a?dl=0
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 |
---|---|
110 | |
99 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |