cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JagodaD Frequent Visitor
Frequent Visitor

Avoiding filtering in some of the vizualizations

years.JPGView before filetring. It should stay like this.2018.JPGView after filtering

 

Hi everyone,

 

I'm creating a dasbaord where I have filters in Filters section on the right side (not slicers). Some of my vizs should be filtered and some of the not. I would like to create a measure that will let me to keep all the years in visual above. How to resole this problem?

 

Thanks in advance.

 

Regards

 

 

9 REPLIES 9
Super User
Super User

Re: Avoiding filtering in some of the vizualizations

Hi @JagodaD 

 

You can Edit Interactivity and set as none, try this video. 
https://www.youtube.com/watch?v=KQsRHWTF4Bs

 

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

 

 

amitchandak Super Contributor
Super Contributor

Re: Avoiding filtering in some of the vizualizations

Try

calculate(sum(sales),all(date[year]))
Community Support Team
Community Support Team

Re: Avoiding filtering in some of the vizualizations

Hi @JagodaD 

 

If you'd like to filter the specific visual, you can perform the change in "Filters on this visual" which won't affect other visuals.

 

0009.PNG

It is not able to use "Filters on this page" to filter only some of the visuals.

 

 

 

 

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

Re: Avoiding filtering in some of the vizualizations

Hi @Mariusz

thanks for your answer. Unfortunately it won't work in my case. I use fileters section, not slicers.

I would be able to use your soultion if I had slicers. I don't want to change my approach because users are already used to it and all of my filters apply to all of the pages.

 

Thanks

JagodaD Frequent Visitor
Frequent Visitor

Re: Avoiding filtering in some of the vizualizations

Hi @v-diye-msft

thanks for your advice but I have around 20 vizuals so I need to have filters that apply to all of the vizuals. It woudn't be user friendly if they have to choose filetrs on every page or vizual.

 

Thanks

JagodaD Frequent Visitor
Frequent Visitor

Re: Avoiding filtering in some of the vizualizations

Hi @amitchandak 

thanks for your answer but I also use "Year" as dimension in my chart so not filetring only "Sales" won't resolve the problem.

 

Regards

amitchandak Super Contributor
Super Contributor

Re: Avoiding filtering in some of the vizualizations

Can you share a sample pbix? After removing sensitive data.

 

Or you can use excel   or pbix to share 

Community Support Team
Community Support Team

Re: Avoiding filtering in some of the vizualizations

Hi @JagodaD 

 

Sorry, I won't know more.

Based on my research, there are no other simple way to meet your requirement currently. The only workaround is setting the filter on this visual and page respectively.

 

 

 

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

Re: Avoiding filtering in some of the vizualizations

Remove connection between first visual' and second visual' table in "Relationship" part. Then filtering on first will not affect second table.

If can't, just create second visual' table copy in query editor, as reference. And then use this copied in second visual.

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 421 members 3,750 guests
Please welcome our newest community members: