Forum Discussion
Default Dashboard Filter
Hi,
How do I default my dashboard filters every time a user opens up a PowerBI Dashboard on the server to show the most recent most and default select that date? Also, is there a way to do this with another categorical string filter, like a "Page Name" for example?
Thanks!
Here is the general approach. Adjust as needed
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/app
7 Replies
Here is the general approach. Adjust as needed
- create a string representation of your date column, replace the latest date with a string "Latest"
- sort that new column by the original date column
- add a slicer or visual/page/report level filter
- set the filter to "Latest"
- publish the pbix to the workspace/appHi lbendlin,
Thank you for this. Can you provide an example? I want the month to still display and I don't want a visible filter for the latest.