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

Need Help

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

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