Forum Discussion
Calendar segments
Dear all,
I want to create a campaing calendar. That is to say imagine:
Cherry: April to august.
Apple: January to December.
And if I select Cherry that filter to the months of the calendar.
I'm thinking something like that:
Var _cherry = months April to August.
Var _apple = months January to December.
And returns two options: Cherry & Apple
Do you know how can I do it?
Hi Luis_Caston
If you use the between type of the slicer, the month slicer cannot affet the date slicer, it will always display the min and max date of the calendar unless you move the it manually, if you want the date filter to be filtered by the month slicer, you need to change the date filter type to dropdown, it can change by the month slicer.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Hi Luis_Caston
You can refer to the following sample.
The date table.
1.Create a type slicer table.
2.Create a measure and put the measure to the visual filter of the date
Measure = IF(ISFILTERED('Table'[Type]),IF(MONTH(MAX('Table 2'[Date]))>=MAX('Table'[from])&&MONTH(MAX('Table 2'[Date]))<=MAX('Table'[to]),1,0),1)Output
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Campaing Segment Calendar Dear Ahmedx , Anonymous
Thank you so much for your support.
I think that the best approuch thinking in a global filter is your .pbix Anonymous but the problem that I've is that I'm not able to convert it as a global filter (to all pages) only to the object.
I upload a .pbix with all the dates and so on.Do you know how I can do something like this:
Hi Luis_Caston
If you use the between type of the slicer, the month slicer cannot affet the date slicer, it will always display the min and max date of the calendar unless you move the it manually, if you want the date filter to be filtered by the month slicer, you need to change the date filter type to dropdown, it can change by the month slicer.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous !
I've tryed your solution but I'm not able to do it.
Please could you check this pbix Calendarv3
Thank you for your support.
pls try this
and pls try this
