Calendar segments

[Luis_Caston]

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?

[Ahmedx]

and pls try this

[Ahmedx]

pls try this

[Luis_Caston]

Hi @Ahmedx !!
This approach is perfect!
Do you know hay can I add it as a column to this calendar?
By the way I'd like to set up three periods:

1 - Apple:
From 08 (year in curse) to 06 of the next year.

2 - Cherry:
From 04 (year in curse) to 07 year in curse.



Calendar 

[Anonymous]

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_Caston]

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.

[Luis_Caston]

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:

Campaing Segment Calendar 

[Anonymous · Accepted solution]

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.