Page Level Filters in PowerBi Desktop

[vat2do]

Hi Everyone,

A quick Question:

Can we have the option to choose specific visuals to apply  page level filters in power bi desktop.

For Example:

I have total 12 visuals on power bi desktop report. out of 12 i want to use a spicific date filter for 8 visuals and another filter for the rest of 4 visuals using PAGE LEVEL FILTER option because if i use visual level filter that will be a big job specially in case of a daily report refresh.

Thanks in advance to provide an easy way out. @amitchandak 

[Idrissshatila]

@vat2do ,

yes you can't limit some visuals by the page level visual, but what you can do is add a slicer to the page and use edit interactions to set that some slicers would filter some visuals and block the filtering on others.

https://learn.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions?tabs=p...

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[danextian]

Hi @vat2do ,

There is no page level filter that will filter just specific visuals in  a page. If you want to apply a filter to a specific visual only then you need to use visual level filters  or write a formula so the filter becomes dynamic with the dataset refresh. For example, if you need to include the dates from yesterday up to six days prior, you can  create a calc column with

=
'table'[date]
    >= TODAY () - 7

This calc colum will return TRUE or FALSE. You only need to set the visual level filter to TRUE once and not every time you refresh your dataset.

[Uzi2019]

Hi @vat2do 
For specific visuals you have to choose visual filter. 
Page level filter- Applies to complete page irrespective of visual level filter.
It follows below sequence   (Auto apply)
Report level filter - Filter (Year(2023)
Page level filter - Filter (Year(2023) - Month( Jan , feb, march etc)
Visual level filter -Filter (Year(2023) - Month( Jan , feb, march etc)- Week (1,2,3 etc)

For your scenario you have to go for different visual filter option.

I hope I answered your question please give kudos and accept it as a solution!
Thanks