Calendar Visual with Start date and End Date

[priyankadureja]

I need to create a Calendar visual in Power BI with start date and end date where values of start date and end date to be passed in the power query using dynamic M query parameters. Would appreciate any help

[priyankadureja]

Thanks a lot for your response. The issue is that as soon as I bind the columnin the date table with the parameters, then calendar visual is not supported. I need to have calendar visual along with the m query parameters which seems not to be supported by ower BI

[v-cgao-msft]

Hi @priyankadureja ,

1. First you need to connect to the data source using DirectQuery.
2. Next, set up your dynamic M query parameters in Power BI Desktop. These parameters will control the start and end dates for your data query. For a step-by-step guide on creating and using dynamic M query parameters, please see Dynamic M Query Parameters in Power BI Desktop.
3. After setting up your parameters, you'll need to bind them to your date table to dynamically filter the date range based on the start and end dates.

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group