Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How do I set default view to be dynamic from date 1-15, then 16-31?
11-29-2023
10:59 PM
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!
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-01-2023
06:09 PM
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

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Top Kudoed Authors (Last Month)
User | Count |
---|---|
2 | |
2 | |
1 | |
1 | |
1 |