Dynamic Slicer Selection

[Anonymous]

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..!!

[ribisht17 · Accepted solution]

@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

[Anonymous]

Thank U @ribisht17 

[amitchandak]

@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=vlnx7QUVYME

calculation groups
https://www.sqlbi.com/blog/marco/2020/07/15/creating-calculation-groups-in-power-bi-desktop/