Forum Discussion
Independent month slicer
Hello,
I would like to introduce a slicer that can select current calendar month, previous calendar month and the calendar month before last.
This slicer has to be independent of any timestamps in the data model. How feasible is it?
Hi , Anonymous
According to your description, you want to "a slicer that can select current calendar month, previous calendar month and the calendar month before last."
For your need , you can try to use the "Relative date slicer" if it can meet your need.
Then we can set the "Last/This/Next" n "Month" for the slicer. And also we can see the date range below it !
For more information, you can also refer to :
Create a relative date slicer or filter in Power BI - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly
1 Reply
- v-yueyunzh-msft
Community Support
Hi , Anonymous
According to your description, you want to "a slicer that can select current calendar month, previous calendar month and the calendar month before last."
For your need , you can try to use the "Relative date slicer" if it can meet your need.
Then we can set the "Last/This/Next" n "Month" for the slicer. And also we can see the date range below it !
For more information, you can also refer to :
Create a relative date slicer or filter in Power BI - Power BI | Microsoft LearnThank you for your time and sharing, and thank you for your support and understanding of PowerBI!
Best Regards,
Aniya Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly