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

Struggling to get Visuals to Interact with Eachother

Hi All,

 

I've been struggling with this all day. Here is a screenshot of my dashboard and I can't get the Treemap to filter the table below. I've tried using measures, two way relationships etc. to no avail. You can see in the screenshot that I'm filtering on the number of new accounts but it doesn't affect the table at the bottom. Any ideas why that might be? Both tables are linking using account numbers so in theory it should filter through but doesn't.

 

The only thing I can think of is that the Values being compared in the Treemap are from two different tables but that's just a guess? If any more details are needed give me a shout.

 

Amos1992_0-1597182945865.png

 

Many thanks,
Rob

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Memorable Member
Memorable Member

Re: Struggling to get Visuals to Interact with Eachother

Hi @Amos1992 ,

 

There are mainly 2 factors due to which filtering might not be happening:

1. No relationship between fields of both visuals

2. Treemap to Table Filtering disabled from Edit Interactions

 

You will need to check the below in such scenario:

1. Relationship must exist between the fields/dataset used in treemap and fields/dataset used in table

2. Take a new table viz for verifying if relationship exists: Pull all the fields from treemap viz and table viz; Now apply visual level filter and check whether filtering is happening

If yes, then relationship exists;

Delete the sample table created in this step later.

3. Make sure the field in treemap's Group has relationship with at least 1 field used in table

4. Check the interaction from Format -> Edit Interaction and confirm if treemap is filtering table or not.

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

View solution in original post

2 REPLIES 2
Highlighted
Super User III
Super User III

Re: Struggling to get Visuals to Interact with Eachother

Hi there

In order for the visuals to interact there has to be a relationship between the tables if you want the visuals to interact.

Or the values from a single table would need to exist in both the treemap and table?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
Memorable Member
Memorable Member

Re: Struggling to get Visuals to Interact with Eachother

Hi @Amos1992 ,

 

There are mainly 2 factors due to which filtering might not be happening:

1. No relationship between fields of both visuals

2. Treemap to Table Filtering disabled from Edit Interactions

 

You will need to check the below in such scenario:

1. Relationship must exist between the fields/dataset used in treemap and fields/dataset used in table

2. Take a new table viz for verifying if relationship exists: Pull all the fields from treemap viz and table viz; Now apply visual level filter and check whether filtering is happening

If yes, then relationship exists;

Delete the sample table created in this step later.

3. Make sure the field in treemap's Group has relationship with at least 1 field used in table

4. Check the interaction from Format -> Edit Interaction and confirm if treemap is filtering table or not.

 

Give a thumbs up if this post helped you in any way and mark this post as solution if it solved your query !!!

View solution in original post

Helpful resources

Announcements
Get Ready for Power BI Dev Camp

Get Ready for Power BI Dev Camp

Mark your calendars and join us for our next Power BI Dev Camp!.

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors