Forum Discussion
Visualisation linking not working as expecting.
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.
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