Forum Discussion

Mon_0Pun's avatar
Mon_0Pun
Regular Visitor
4 months ago
Solved

Visual

Is there a way in Power BI to apply filters to an entire page but prevent those filters from affecting a specific visual? For example, I have a report with multiple page-level filters and a slicer v...
Need Help
  • grazitti_sapna's avatar
    grazitti_sapna
    4 months ago

    Hi Mon_0Pun,

     

    You need to use the measure in your visual and not as slicer or visual filter. If you are using sematic model or a live connection you should still be able to create a table n top of it.

     

    I've created a sample .pbix file showcasing the page level filter, Edit interaction and Visual level filter without creating a new table. hope this clarifies how you cn inplement the same.

     

     

Mon_0Pun's avatar
Mon_0Pun
Regular Visitor
4 months ago

Thanks grazitti_sapna for the providing the solution. I used your remove filter measure, but I am unable to use that measure in my filter visual. Also my access is restricted to create any table or column.

grazitti_sapna's avatar
grazitti_sapna
Super User
4 months ago

Hi Mon_0Pun,

 

You need to use the measure in your visual and not as slicer or visual filter. If you are using sematic model or a live connection you should still be able to create a table n top of it.

 

I've created a sample .pbix file showcasing the page level filter, Edit interaction and Visual level filter without creating a new table. hope this clarifies how you cn inplement the same.