cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nmck86 Member
Member

Filtering issue

Hello,

 

I had a question, I am creating two different charts based on employee type data in PowerBi. One chart is based on Retiree information and the other is based on Regular employee info. However, since the 2 charts on are on the same page PowerBI keeps forcing both charts to have the same exact data on each. I tried ot create the second Chart on another page and then cut it into the other page but once I get it on the page it defaults the filters to the same as the chart that was already on the page. Any idea how I can fix this? Thanks in advance for your assistance!

3 ACCEPTED SOLUTIONS

Accepted Solutions
FarhanAhmed1984 Regular Visitor
Regular Visitor

Re: Filtering issue

Hi,

 

If you have published in Web then you can change the interaction of Visuals i.e. (dependency on other)

 

Click Edit Report

- Visual Interaction

- On every visual you can select if filter can be applied on it or not? (refer screen shot)

 

Edit Report.png

View solution in original post

Highlighted
nmck86 Member
Member

Re: Filtering issue

Ah I figured it out! Page level filter caused the issues :-). Thanks for the assistance!

View solution in original post

v-huizhn-msft Super Contributor
Super Contributor

Re: Filtering issue

Hi @nmck86,

If you have resolve your issue, please mark the corresponding reply as answer, which will help others find solution easily. Thanks a lot.

Best Regards,
Angelia Zhang

View solution in original post

5 REPLIES 5
Sean Super Contributor
Super Contributor

Re: Filtering issue

@nmck86

 

Select either Chart => Format tab => click Edit Interactions =>hit the None (circle) in the top right corner on the other chart

 

then you can click Edit Interaction again to exit that mode

 

Good Luck! Smiley Happy

 

EDIT: I did respond for the Desktop being that this is the Desktop Forum and the question did not specify the Service! Smiley Wink

FarhanAhmed1984 Regular Visitor
Regular Visitor

Re: Filtering issue

Hi,

 

If you have published in Web then you can change the interaction of Visuals i.e. (dependency on other)

 

Click Edit Report

- Visual Interaction

- On every visual you can select if filter can be applied on it or not? (refer screen shot)

 

Edit Report.png

View solution in original post

nmck86 Member
Member

Re: Filtering issue

I tried the none option in the interactions section; however, everytime I change the filter in one chart it still changes it in the other chart as well. :-(. I am in the desktop version currently. Am I am possibly doing something else wrong?

Highlighted
nmck86 Member
Member

Re: Filtering issue

Ah I figured it out! Page level filter caused the issues :-). Thanks for the assistance!

View solution in original post

v-huizhn-msft Super Contributor
Super Contributor

Re: Filtering issue

Hi @nmck86,

If you have resolve your issue, please mark the corresponding reply as answer, which will help others find solution easily. Thanks a lot.

Best Regards,
Angelia Zhang

View solution in original post

Helpful resources

Announcements
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.

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.

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: 232 members 2,468 guests
Please welcome our newest community members: