Forum Discussion

SimG's avatar
SimG
Regular Visitor
2 years ago

Report parameter resets to default value when selection of any other parameter is changed

Hi All, I am currently stuck with an issue in Power BI service wherein: Changing selection of any other parameter resets date parameters' user selection to its default value. I have searched around...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi SimG ,

This may be related to the way the Power BI service handles parameter dependencies and refreshes. When publishing to a Power BI service, the dynamic nature of the service may trigger a reset of dependent parameters when any changes occur.

You can try the following steps to resolve the issue:

  1. Check the parameter configuration to ensure that there are no unexpected dependencies that might cause this reset behaviour. Refer to the following link for more information:
    Edit parameter settings in the Power BI service - Power BI | Microsoft Learn
  2. If the problem is indeed due to the way the Power BI service handles parameter dependencies, consider using DAX to dynamically manage default values in the data model.

Best Regards,

Ada Wang

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

  • SimG's avatar
    SimG
    Regular Visitor
    2 years ago

    Hi Anonymous ,

     

    Thanks for giving a thought on this issue. Actually the report i am working is a paginated report and default values work fine when i run report on Power BI Report Builder but on Power BI Service the user selection in Date Parameters is overwritten by its default value on change of other parameter. I tried the thing you suggested in 1st point and i wonder i don't see any tab for 'Data Set' as mentioned in the link Edit parameter settings in the Power BI service - Power BI | Microsoft Learn

    Also, there is nothing in'Semantic Models' tab. 

    I am not sure how can i dynamically manage default values of date parameters in Power BI Report builder so that user selection is also retained when any parameter changes in Power BI Service as well.

     

    Thanks & regards.