Dynamic parameter value change in Power BI desktop does not update the chosen value immediately

[pearl2]

Dear Experts,

I have created dynamic parameter for say the field Year. The parameter is created with a list of different years the users can choose from. The users view the report from Power BI desktop directly. Power BI service is not used. The dynamic parameter is created in power query--> "enable load" checked for the parameter. I can now see and use this parameter in the report View--> Transform data--> edit parameters(screenshot attached). For instance, the default year is set to 2023 and the user selects 2024 from this dynamic parameter. The report data gets refreshed as soon as they select. however, i have also created a Card Visual for them to see on the report display to show which year they have selected. That card value is what remains the same until the main 'refresh' option is clicked on the report view. The want the year value on the card visual to change immediately upon the change in dynamic parameter value just like the report data gets updated immediately.

Any advice or suggestions are much appreciated.

Regards,

Pearl

@powerbidesktop, @dynamicparameterrefresh @reportrefresh

[Anonymous]

Hi @pearl2 ,

If your data connection mode is Direct Query mode, then you can try using the Dynamic M query parameters approach. You can create an additional table, let's call it Slicer, create a field Year in it (since you mentioned that you are selecting Year in your parameter), then bind the parameter you created to that field and create a slicer from that field for your user to select the year.
Then, you can is to use the following DAX to create a measure to put into your Card Visual:

measure = SELECTEDVALUE('Slicer'[Year])

This should enable dynamic changes in what is displayed in the Card.

Note, however, that there are numerous limitations to this method. In addition to the fact that it only works in Direct Query mode, as I mentioned above, it has limitations in other areas, as described in this document:
https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-dynamic-m-query-parameters#considera... 

If you are not in Direct Query mode, or if your situation involves a limitation, there may be no other way to achieve your expected results.

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

[pearl2]

Hello @Anonymous thank you for your response. I appreciate it. However, I am using import mode in my report and hence the bind parameters option is not really available. thank you again.