Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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).
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.