Forum Discussion

vat2do's avatar
vat2do
Helper III
2 years ago

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 r...
Need Help
danextian's avatar
danextian
Super User
2 years ago

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.