Forum Discussion
create a dynamic calendar from a date
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.
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.
3 Replies
For example if i select the date november in the segment, it should create a calendar of 6 months that begins in december
v-xiaotangCommunity Support
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.
thank you very mucch
