Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Score big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount

Reply
Ben83
Advocate IV
Advocate IV

Exclude a visual from the report filter?

Is there a ability to exclude a visual from the report filter? I have a line chart which I want to filter over a separate time range (last 12 month) as the rest of my visuals (last month).

1 REPLY 1
greggyb
Resident Rockstar
Resident Rockstar

There's no way to alter a visual to ignore the report filter. You can write a measure that would ignore the filter context from the report-level filter.

 

A sample.

AmountBase =
SUM( 'FactTable'[Amount] )

AmountRolling12 =
CALCULATE(
    [AmountBase]
    ,DATESINPERIOD(
        DimDate[Date]
        ,MAX( DimDate[Date] )
        ,-12
        ,MONTH
    )
)
        

This depends on a date dimension (google "power pivot date dimension" if you don't have one. Make or acquire one if you don't have one. This conversation is not worth having if you don't have one) that is related to your fact table on DimDate[Date] = FactTable[Date].

 

The MAX() in the DATESINPERIOD() will be evaluated in the report filter context, so if you have a filter for the current month, MAX( DimDate[Date] ) will be the last date in the filter month. You could alternately use TODAY() instead of the MAX() to have the rolling 12 month period determined by the system date at time of running the report.

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.