Power bi - Filters and Slicers affecting this visaul

[msgsupriya]

Hi,

I am a newbie to Power BI.

Have created the attached report - but when I click on some values in the Tree Map - the filters on the rest of the visuals does not get updated.

eg. In the screen capture shows 3 filters - but it should not show the Included (1) filter.

It looks like it remembers the last selection, which is causing issues. Due to which the vasuals are blank and have error (Blank)

Any way to reset the filters each time a value is clicked?

Thanks

[amitchandak]

@msgsupriya , refer

https://medium.com/@vaishaligoilkar3322/include-and-exclude-in-power-bi-7a9262cf434f

Also refer

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

[AllisonKennedy · Accepted solution]

@msgsupriya

The 'include' filter is unique and stays in place as you interact with the rest of the report. You can remove it by selecting the chart you placed it on and deleting the filter from the filters pane. See if this post helps more with include/exclude:
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-october-feature-summary/#:~:text=Include%2....

I suggest using the Filters pane or slicers to do your dynamic filtering.