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
Michael_Hammer
New Member

Report Filter is filtering all reports on a page rather than the one selected

Good Day PBI Community,

 

I've got a dashboard with 2 area charts and a Gauge.  I want the gauge to have a REPORT level filter (just for that single gauge) that doesn't affect the area charts.  However no matter where I place the filter (in PAGE filter or REPORT filter), every item on the page becomes affected by it.

 

Is this a bug? Or am I doing something wrong?

 

Thanks,

Michael

1 ACCEPTED SOLUTION
HarrisMalik
Continued Contributor
Continued Contributor

This is not a bug it is designed like this:

 

-Page level filter effects all the visuals on that page

-Report level filters effects all the visuals on all the pages of a report

 

Regards

 

Harris

View solution in original post

4 REPLIES 4
HarrisMalik
Continued Contributor
Continued Contributor

This is not a bug it is designed like this:

 

-Page level filter effects all the visuals on that page

-Report level filters effects all the visuals on all the pages of a report

 

Regards

 

Harris

LetBloodline
Frequent Visitor

If not all visuals on the page must be filtered it's not a common page level nor report level filter

 

You can make a workaround

 

Make a DAX mesure for those 2 visuals that remove the page/report filter

Not Filtered Sales = CALCULATE([Sales];ALL('Date'[Year]))

 

OK Thanks.  I came from another tool that handled these in the opposite fashion.  Each visualization was a "report" and a page was what you could see on a screen and a "Book" was multiple screens.

@Michael_Hammer what hasn't been mentioned here is the 3rd filter that you are looking for, the "Visual Level Filter" - this is the filter that will only effect your gauge (or the visual you have clicked on). You will always see the Page and Report level filters, but must be in the the context of a visual to see the filter you want.


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG

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.