how to exclude table level filters in power bi

[sridharbabu]

I have a table loading last 2 moths of data. eg. nov, dec by placing top n= max(monthnumber). we dont have date table. now the requirement is to display last 3 months of data. eg. oct,nov,dec . 

In simple term loading 2 months of data, but has to show 3 months data. 

For table applied topn visual level filtter. applied all but not working.

[danextian · Accepted solution]

Hi @sridharbabu ,

Filters are evaluated against the report, page or visuals and cannot be excluded or disabled. Attached is a sample pbix that shows the last 12 months based on slicer selection. This makes use of separate dates/calendar table that doesn't have a relationshiop to the fact table.