Forum Discussion
Add date picker options
How to add these date picker options
- Today
- Yesterday
- Last 7 Days
- Last 30 Days
- This Month
- Last Month
- This Year
- Last Year
- Custom
I need them to be the options in the report and once chosen, data will be updated.
Thank you.
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.
5 Replies
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-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://www.youtube.com/watch?v=vlnx7QUVYMEmultiple 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-Last-Week/ba-p/1051123
Power BI — Day Intelligence
https://medium.com/@amitchandak.1978/power-bi-day-intelligence-questions-time-intelligence-5-5-5c3243d1f9hi amitchandak thanks for these links.
Will check and revert back to you if I encountered issue 🙂
gilbertendaya , refer this one for custom combination
