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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
add
Frequent Visitor

Stop filter affecting forecast

Hi Everyone,

 

I'm currently building a report which contains 5 years worth of data but the majority of the time my users only need to see the current financial years data. 

 

The issue I have come accross is that the forecast changes when a filter is applied, one of the major reasons so much data is being used is to help identify trends. So is there a way of filtering a visual without affecting the forecast? 

 

Thanks.

2 REPLIES 2
ADPowerBI1
Responsive Resident
Responsive Resident

Select the filter, then go here:

ADPowerBI1_0-1675868997495.png

To edit interactions, click edit interactions then select "None" on the top right of the visual you don't want filtered!

 

please accept as solution if this helped. Thanks! 🙂

 

Sorry I should have explained. I still want the rest of the visual to be filtered just not the forecast.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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