Forum Discussion

shemclavo08's avatar
shemclavo08
New Member
2 years ago

How do I set default view to be dynamic from date 1-15, then 16-31?

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

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    2 years ago

    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