Forum Discussion
Page Level Filters in PowerBi Desktop
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
3 Replies
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!
ThanksHi 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 () - 7This 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.
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.
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 💡
