Default selection retained on filter pane even when the value does not exist in backend

[supriyapandey19]

Hi,

I need a solution to the problem that while publishing the report to service, I provided some default selections on filter pane. Then in future when data upated, we no longer have data for one of the default selections so that value should not be visible on filter pane but the filter pane is retaining that default selection even though data doe not exist in backend.

Please help.

[v-cazheng-msft · Accepted solution]

Hi @supriyapandey19 ,

It is primarily because Power BI stores report metadata and dataset separately. Hence, when you open the report after some items remove from data source and do refresh against the data source, the data itself does remove from the dataset but the selection on the report still exists. You could do these operations to make the change reflected to your report.

if these filters are set in Reading mode of the report, refresh the visuals on the report, and manually tick another choice on it or click on Erase icon to clear the filter. If the selection on filter pane is saved with the original report, you need do it in Edit mode of the report.

Best Regards,

Community Support Team _ Caiyun

[edhans]

Design decision. Same happens with slicers. If the data changes, you have to change your default. Power BI assumes that data might come back so retains your choice. Otherwise reports with lot of pre-set selections would wipe them out if there was a single bad refresh with bad data.