Forum Discussion

iamflamingjune's avatar
iamflamingjune
Frequent Visitor
6 years ago

Visualisation linking not working as expecting.

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...
Need Help
iamflamingjune's avatar
iamflamingjune
Frequent Visitor
6 years ago

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's avatar
v-lionel-msft
Community Support
6 years ago

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.