Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I am creating a report and one of the requirement is to set the default view to be dynamic.
Sample:
For dates that fall on December 1-15, default view should be these dates.
For dates that fall on December 16-31, default view should be these dates.
I have tried looking into filters, and DAX formulas. But just can't seem to find the one appropriate for the use case.
Thank you!
Here's the basic pattern:
- 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
Check out the July 2025 Power BI update to learn about new features.