Parameter value not updating in Report View

[AutoJL]

Hi everyone!

I am using a parameter  of type list to change the data source of my dashboard. The data source is a Sharepoint folder and I use the parameter to point to different users folders. So far the parameter seems to be working in doing its job: i change the param, the data is refreshed with the new folder, it changes in powerquery but....

I have a card visual on my report to show the current value of this parameter and it doesnt change at all. Furthermore in the data view I can confirm the value is not changing as the column still displays the default value ( or the first one I used not sure ). The thing is if I straight go into transform data -> edit parameter it does show the current value. Same thing on powerQuery editor and the whole report does change according to the new folder given by this parameter.

Can anyone help me understand what is going on here and how to fix it ?

Many thanks in advance!

[AutoJL]

Hi @v-yanjiang-msft !

Sorry for the massive delay in the response but you caught me with all the summer holidays and also while exploring aroun your suggestions I did some troubleshooting and analysis that kept me busy.

Many thanks for the support! In case it is of help for some other users ill give some feedback on the suggestions.

Starting from the end, since the issue that I am facing appears already on PowerBI desktop before publishing I dont think it is related to the pin visual vs pin live page. Also not sure about the second option  maybe that is related to the field parameters feature? It is indeed very strange that not even in the table view the parameter is reflecting the changes.

Lastly I tried your suggestion of using a parameter of suggested value query and this indeed worked a lot better. It didnt really "fix" the main issue since this is also not refreshed instantly but I realized both params require a manual click of the refresh data button. By this I mean: if you change the param you will be prompted to refresh since actually changed, this will work correctly in using the new directions that the param value hold but, for some reason it wont "update" de param itself, if you again hit the refresh button it will.

In any case what I chose to do is create a new blank query and add one line that is actually the param value. Using the "table" ( it only really contains one column and one row but it technically is a table) that this query creates I do get the changes in the params instantly.

Also your suggestion to use the query value on the param was very helpfull because I no longer need to update the param each time I chose to add someone to the sharepoint list, now it instanlt refreshes.

Many thanks again for the help and sorry for the late response.

[v-yanjiang-msft]

Hi @AutoJL ,

Has your problem beed solved? If so, please kindly accept the helpful reply as solution, then we'll close the thread, other people who has the similar problem will benefit from here. Thank you!

Best regards,

Community Support Team_yanjiang

[v-yanjiang-msft · Accepted solution]

Hi @AutoJL ,

According to your description, I did some research and found some possible solutions for you.

One possible reason why your card visual is not updating is that you are using a parameter of type list, which is a static list of values that you define in the Power Query Editor. If you want to use a dynamic list of values that can change based on your data source, you need to use a parameter of type query instead. A query parameter allows you to reference another query that returns a list of values. You can then use the query parameter in your data source settings to point to different folders. 

Another possible reason why your card visual is not updating is that you are not using the parameter correctly in your visual properties. You need to make sure that the parameter is used as a field in the visual, not as a filter or a measure. You also need to choose whether the parameter shows the values or the display names of the selected fields. To do this, you can click on the down arrow next to the parameter name in the Values box and select Show selected field or Show display name

A third possible reason why your card visual is not updating is that you are using a pinned visual instead of a pinned live page. A pinned visual is a static snapshot of the visual that does not reflect any changes in the underlying data or parameters. A pinned live page is a dynamic view of the report page that updates with any changes in the data or parameters. To pin a live page, you need to click on the pin icon at the top left center of your report space and select the dashboard you want to pin it to. 

Reference: Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

Solved: Card is not updating in Dashboard - Microsoft Fabric Community

Best Regards,
Community Support Team _ kalyj

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