Visualisation linking not working as expecting.

[iamflamingjune]

I am a relative PowerBi newbie and have come against a bit of a wall, when trying to get the highlight function to work on one of my visuals in a dashboard.

I had it working, prior to me changing how i collected the data.

This is an example of the interaction that is working on the same dashboard. By clicking on the Issue Bar graph, the Issue by House tree map is using the highlight feature that im after.

When i do it the other way round... the highlight function 'breaks'
So clicking on the House in the treemap doesnt change any other visuals, even though they have the highlight function selected.

Originally i had the House detail in a single column, but have split it out into numerous columns to assist with the reporting and it looks like this... with the visual counting the number of Y's in a column

I suspect i need to assign the relationship somewhere, but im at a lost and would appreciate some assistance.

thanks in advance

[amitchandak]

Your report is fully packed.  It is possible when you click on visual it is hiding behind another visual.

The way to do is to click on a visual. That is the main visual, now you should only click or filter, fill or stop icon on other visuals.

[iamflamingjune]

@amitchandak  thanks for coming back so quickly... i cant find any other visuals behind or on top of the visual that isnt interacting... i have found that if i use the group section.. i do get interaction... but the visual makes no sense to me, as it includes all the blank rows.. that i dont want to count..

[v-lionel-msft]

Hi @iamflamingjune ,

1. When you clicked on the Issue Bar graph, the Tree Map didn't change.

In fact, this may be normal. You can do a test:

First, create three measures.

c1 = COUNT([Hourse 1])
c2 = COUNT([Hourse 2])
c2 = Count([Hourse 3])

Second, add the three measure to card visual.

At last, click on the Issue Bar graph and observe the changes in the three measures. If the value does not change, the Tree Map will not change. Interaction is actually a sort of filter behavior.

2. When you clicked on the the Tree Map, the Issue Bar graph didn't change.

This is because your Tree map has too few coordinate dimensions (you did not add the Group axis) 

To solve the above two problems:

Add the Group axis in the Tree Map (divide the data into more subdivisions). 

But your columns contain null values, so you may need to modify the data model based on business needs.

Best regards,
Lionel Chen

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

[iamflamingjune]

thank you @v-lionel-msft 

i have re-organised the original data... so i no longer have any blanks..

Each House that has an issue in, i now mark it with a 1

 and this is how it now looks in the visual (which i exactly what im after).

but still doesnt have the interactivity with the other graphs... If i use the grouping axis... and put all the houses in, it looks like this...



So now, im getting a portion of map for every combination of Houses... So for example if the issue was in Sheds 2 and 3 only (0,1,1,0) its showing it as a seperate portion of the map.. I just want it to count that the issue occured in Shed 2 and Shed 3 seperately, as the 2nd screengrab showed.. So is it a filtering, exclusion, inclusion setting that i need to include ?

This is how it looks in the structure. 

im sure its really easy... im just pulling my hair out, as to the logic i need to apply.

thanks in advance