Forum Discussion
Calendar segments
- Anonymous2 years ago
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 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.
- Luis_Caston2 years agoHelper III
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:
- Anonymous2 years agoNot applicable
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.
- Luis_Caston2 years agoHelper III
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.