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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Angel
Resolver III
Resolver III

Avoid filter to apply in one visual

Hi, everyone

 

I have tried that only one visual in the page will be not affected by a filter page. The field is 'Invoice Creation Date'.

 

The problem is when I create the line graph. I use 'Invoice creation date' as axis, and obviously it is only show values of the filter 'Invoice Creation Date'.

 

I have tried using DAX, but the result is the same.

 

¿Does anyone knows any idea?

 

Thanks in advance,

 

 

 

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

hi  @Angel 

If you want to avoid a slicer filter to apply in one visual, you could edit inrteractions for this visual.

 

If you want to avoid page level filter (filter on this page) filter to apply in one visual, this could not achieve in power bi for now, you have to set visual level filter for each visual.

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

5 REPLIES 5
maulopez
Advocate I
Advocate I

Here's what I did for this scenario. Say you have [Measure 1] being used in a certain visual and 'Table X'[Column Y] is being used as a filter in the Filters Pane. Just make a new measure like this:

 

Measure 2 = CALCULATE( [Measure 1], REMOVEFILTERS('Table X'[Column Y]))

 

and use [Measure 2], it won't be filtered by 'Table X'[Column Y].

 

Or alternatively, "block" the whole 'Table X' from filtering in [Measure 2], like this:

 

Measure 2 = CALCULATE( [Measure 1], REMOVEFILTERS('Table X'))

 

Hope this helps.

v-lili6-msft
Community Support
Community Support

hi  @Angel 

If you want to avoid a slicer filter to apply in one visual, you could edit inrteractions for this visual.

 

If you want to avoid page level filter (filter on this page) filter to apply in one visual, this could not achieve in power bi for now, you have to set visual level filter for each visual.

 

Regards,

Lin

Community Support Team _ Lin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Pragati11
Super User
Super User

Hi @Angel ,

 

Can you please elaborate on your query with some screenshots?

Do you mean how to disable Page level filters on a visual?

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Hi @Pragati11 

 

It means disable page level filters on a visual.  Something similar when slicers are used and you can avoid one visual will be affected by the slicer...

 

Thanks,

Hi @Angel ,

 

Not sure if you tried looking for the solution in existing threads. One of the thread I found is:

https://community.powerbi.com/t5/Desktop/How-to-exclude-one-visual-from-page-filters/td-p/664515

 

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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