Forum Discussion
Helper IIIFilter Pane TopN doesn't allow choice
Since the latest update, the TopN option in the filter pane doesn't allow choices of what to filter on.
For example, I want to filter a visual by the MaxDate, so usually I choose Top 1 and then by value Latest Date. Now, when I try this it only allows for earliest and the dropdown is greyed out
Any ideas?
3 Replies
Ensure that the field you're trying to filter on is correctly formatted as a date in your dataset. If it's not recognized as a date, Power BI might not offer the correct options.
Sometimes, the relationships or the way the data model is structured can affect how the filtering works. Make sure your date field is appropriately related to other tables in your model if it's necessary.
JB_ATThank you for replying. The format is correct. I tried some variations and I still can't change the options. I also tried to use a non date field and it's the same result. Could it be setting related?
I think this is a bug. Try create another version of your report WITHOUT any Calculation Group. It should work. Sadly, this problem still exists on Power BI Desktop April 2025 version. Hope someone report this problem.
