Add date picker options

[gilbertendaya]

How to add these date picker options

1. Today
2. Yesterday
3. Last 7 Days
4. Last 30 Days
5. This Month
6. Last Month
7. This Year
8. Last Year
9. Custom

   I need them to be the options in the report and once chosen, data will be updated.

   Thank you.

[amitchandak]

@gilbertendaya , you can use a relative date slicer if it works.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

Otherwise have to create a measure slicer like

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...
https://www.youtube.com/watch?v=vlnx7QUVYME

multiple measures can change based on selection

For values you need to refer

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

Power BI — YTD
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
Power BI — QTD
https://medium.com/@amitchandak.1978/power-bi-qtd-questions-time-intelligence-2-5-d842063da839
Power BI — MTD
https://medium.com/@amitchandak.1978/power-bi-mtd-questions-time-intelligence-3-5-64b0b4a4090e
Power BI — WTD
https://medium.com/@amitchandak.1978/power-bi-wtd-questions-time-intelligence-4-5-98c30fab69d3
https://community.powerbi.com/t5/Community-Blog/Week-Is-Not-So-Weak-WTD-Last-WTD-and-This-Week-vs-La...
Power BI — Day Intelligence
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c324...

[gilbertendaya]

hi @amitchandak  thanks for these links.

Will check and revert back to you if I encountered issue 🙂

[amitchandak]

@gilbertendaya , refer this one for custom combination

http://sqljason.com/2018/03/display-last-n-months-selected-month-using-single-date-dimension-in-powe...

[Tahreem24 · Accepted solution]

@gilbertendaya ,

Simply take slicer from visualization pane --> drag Date column into it --> click on "Down Arrow" on that visual at top right cornor --> Select "Relative Date" option. For your convience I am also attaching screen shot.

 

[gebberryOffice]

This doesn't solve custom dates.. which is the issue.. you have to get into crazy complicated book marks to choose Jan to March only when you are in april, or feb only when you are in april... or republish..its close..but date selection should be much easier to choose from all the options.. MS has some work to do still