The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance 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