Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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..!!
Solved! Go to Solution.
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
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
@ppatil , 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/50...
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
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/
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |