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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
ShivaPrasad1
Helper I
Helper I

Difference between page level filter, report level filter and visual level filters?

How these page level filter, report level filter and visual level filters are differ from one another in real time usage?

2 ACCEPTED SOLUTIONS
v-shex-msft
Community Support
Community Support

Hi @ShivaPrasad1,

 

First, they had different filter range.(Report > Page > Visual)
Second, power bi use 'and' logic to apply them on contents and visualizations. So if you enable conflict filters on different level, it will shows blank because no item can match the conditions.

 

Reference:

5 Power BI Tips To Make Your Reports More Appealing And User-friendly

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Anonymous
Not applicable

A Report can have 1 or more Pages.  A Page can have 1 or more visuals.  These sections let you set up filters to cover over these groupings to save you having to duplicate things.

For Example:  You might have to do a report that covers only a certain country, but your data set has data for the entire world.  So you can set a "Report Filter" to only ever show that country.

 

Next you might need to create a different report page for each city.  Each city is very different in the metrics they need to display, so you need to make sure you hand craft each page on your report.  So, per page, you would set up the City in the Page Filter.

 

Lastly you might be working on a specific graph, this graph might be looking at data that is only concerned with familes that have children.  So you could set up a filter on just that visual that only shows data of people with children.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

A Report can have 1 or more Pages.  A Page can have 1 or more visuals.  These sections let you set up filters to cover over these groupings to save you having to duplicate things.

For Example:  You might have to do a report that covers only a certain country, but your data set has data for the entire world.  So you can set a "Report Filter" to only ever show that country.

 

Next you might need to create a different report page for each city.  Each city is very different in the metrics they need to display, so you need to make sure you hand craft each page on your report.  So, per page, you would set up the City in the Page Filter.

 

Lastly you might be working on a specific graph, this graph might be looking at data that is only concerned with familes that have children.  So you could set up a filter on just that visual that only shows data of people with children.

v-shex-msft
Community Support
Community Support

Hi @ShivaPrasad1,

 

First, they had different filter range.(Report > Page > Visual)
Second, power bi use 'and' logic to apply them on contents and visualizations. So if you enable conflict filters on different level, it will shows blank because no item can match the conditions.

 

Reference:

5 Power BI Tips To Make Your Reports More Appealing And User-friendly

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.