Forum Discussion

priyankadureja's avatar
priyankadureja
Frequent Visitor
2 years ago

Calendar Visual with Start date and End Date

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

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • priyankadureja's avatar
    priyankadureja
    Frequent Visitor
    2 years ago

    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