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

       

       

       

      • iamflamingjune's avatar
        iamflamingjune
        Frequent Visitor
        6 years ago

        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