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.
Hello!
I have a date slicer that filters some payment dates for me which I have set for the next 4 months. It originally uses today's date.
I need to have the date be the beginning of every current month instead of the current day so instead of below:
It would be 11/1/2022 - 02/28/2023 (Relative to this month November) and change when December comes etc...
Any help is appreciated,
thanks!
Solved! Go to Solution.
Oh,
You mean the first of the current month and the next 3 months. it is a combination of past and future.
In my idea, you need to create another date dimension that is included the all current month and next 3 months based on the current month
Hi,
There is another choice in the last drop-down in the specific visual (Months (calendar), when your choice that, it is shown the particular months date regarding the number you entered :
As you see I chose the Next- 3 - Months (calendar) and the dates are filtered between 1/12/2022-28/02/2023
Appreciate your Kudos and Please mark it as a solution if it helps you.
Hello Mahyar,
This option will make the filter go to the next 3 months starting the next month, so choosing it would lead the filter to start at December 1st instead of November 1st..
Oh,
You mean the first of the current month and the next 3 months. it is a combination of past and future.
In my idea, you need to create another date dimension that is included the all current month and next 3 months based on the current month
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 |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |