cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bob57
Helper III
Helper III

Page level date filter using unrelated table as slicer.

Hello,

Client has requested that a page level date filter exist to filter by: Today, This week, This month,This Quarter, This year, Last 3 months, Last year, and Specified date range. I thought to create an unrelated table using these selections, create a slicer with these table vaules, and then write measures testing the value of the slicer and invoking the appropriate date filter in the calculation based on the slicer value. Seems cumbersome. I suspect ther is a more efficient and elegant method that escapes my novice ability. Below shows a mock report. Here is a link to the mock report: https://techservicesllc-my.sharepoint.com/:u:/p/bstorie/EeTg-8iRNo1Oqr8aA7ZKV3YBUAaSQsyOwI6lQDAsSsL7.... Let me know if there is anything else I can offer to help you to help me. As always, I am most appreciative of your timem and effort.

Bob

 

bob57_0-1614286610048.png

 

1 ACCEPTED SOLUTION
Portrek
Resolver II
Resolver II

Hi, you can choose the option inside the slide filter options and select the date relative point.

Watch this video below, maybe helps you.

 

https://www.youtube.com/watch?v=CoTLQiMZFbI

 

Other option is biuld a filter painel using bookmarks.

See you.

View solution in original post

2 REPLIES 2
Portrek
Resolver II
Resolver II

Hi, you can choose the option inside the slide filter options and select the date relative point.

Watch this video below, maybe helps you.

 

https://www.youtube.com/watch?v=CoTLQiMZFbI

 

Other option is biuld a filter painel using bookmarks.

See you.

View solution in original post

Thank you. This offers a plausible option for me.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.