create a dynamic calendar from a date

[zaza1098]

Hello. Please I need help. I want to create a visual that distributes an amount to the next few months, based on a selected month in a segment. For example, I have 60 days to distribute in quantities of 20, over the next 6 months. The example in picture. My problem is that I can't create the calendar from the selected date in the filter segment.

[v-xiaotang · Accepted solution]

Hi @zaza1098 

Thanks for reaching out to us.

It is not possible to create calendar dynamically according to the value selected in slicer. Usually, we use slicer to get a period, please read the articles below

https://community.powerbi.com/t5/Desktop/Filter-Slicer-to-show-next-6-months/m-p/185540

Show last 6 months based on user single slicer selection - YouTube

If you need more help, please let me know.

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.

[zaza1098]

thank you very mucch

[zaza1098]

For example if i select the date november in the segment, it should create a calendar of 6 months that begins in december