Forum Discussion
Dynamic parameter value change in Power BI desktop does not update the chosen value immediately
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#considerations-and-limitations
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.
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.