Forum Discussion
Dynamic Slicer Selection
Hi Community..!!
I need to create a Daily, monthly, weekly, quarterly and yearly dynamic slicer and on the basis of it we need to see the trends on sales. How can we achieve this.
Please refer the below table.
dates Index week sales
| 01 July 2022 | 1 | 27 | 500 |
| 01 February 2022 | 2 | 6 | 500 |
| 01 May 2022 | 3 | 19 | 500 |
| 01 March 2022 | 4 | 10 | 500 |
| 01 April 2022 | 5 | 14 | 500 |
| 01 January 2022 | 6 | 1 | 500 |
| 01 August 2022 | 7 | 32 | 500 |
| 01 October 2022 | 8 | 40 | 500 |
| 01 September 2022 | 9 | 36 | 500 |
| 01 December 2022 | 10 | 49 | 500 |
| 01 June 2022 | 11 | 23 | 500 |
| 01 November 2022 | 12 | 45 | 500 |
Thanks in advance..!!
Anonymous
Please check this post Solved: Dynamic Date Slicer including a Week and Quarter o... - Microsoft Power BI Community
Regards,
Ritesh
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My You Tube Channel !! Connect on Linkedin
3 Replies
Anonymous , check measure slicer
measure slicer
https://www.youtube.com/watch?v=b9352Vxuj-M
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://www.youtube.com/watch?v=vlnx7QUVYMEcalculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/Anonymous
Please check this post Solved: Dynamic Date Slicer including a Week and Quarter o... - Microsoft Power BI Community
Regards,
Ritesh
Regards,
Ritesh
Mark my post as a solution if it helped you| Munde and Kudis (Ladies and Gentlemen) I like your Kudos!! !!
My You Tube Channel !! Connect on LinkedinThank U ribisht17
