Forum Discussion
Default selection retained on filter pane even when the value does not exist in backend
Hi Anonymous ,
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
Hi Anonymous ,
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
Is there a way to disable metadata/cache storage to avoid this problem as for a published dashboard, not all users would be aware of following the steps you mentioned