Forum Discussion

chrisgehm's avatar
chrisgehm
Helper III
9 years ago

Show components while passing mouse over graph

Hi everyone!

 

 

I'm trying to show in a graph some values and its names or description, per month.

For example:

 

So what I want is that when I move the mouse over the graph, to show each elemment tha is in the month I step over

 

 

For example, in the image, if I stand over month 1, I would like to show the month, the total amount, and each object that is in that month. In the case I choose month 1, I would like to show object A, B and C.

 

Is it possible?

 

Kind regards

Need Help

12 Replies

  • Sean's avatar
    Sean
    Community Champion
    9 years ago

    The easiest way would be to place Object in the Legend like this

    Otherwise you have to write Measures for each Object and place in the tooltips like this...

    The Measures are very simple however depending on how many you actually have it may take some time

    Object A = CALCULATE ( SUM('Table'[Amount]), 'Table'[Object]="A")
    
Object B = CALCULATE ( SUM('Table'[Amount]), 'Table'[Object]="B")
    
Object C = CALCULATE ( SUM('Table'[Amount]), 'Table'[Object]="C")
    
Object D = CALCULATE ( SUM('Table'[Amount]), 'Table'[Object]="D")

    Hope this helps!:smileyhappy:

    • chrisgehm's avatar
      chrisgehm
      Helper III
      9 years ago

      Thanks for the answer Sean

       

      Actually, I've got over 1000 objects, so I can't do a measure for each object.

      I've tryed to drag "Object" to the legend field, but I can't.

       

      Any idea why?

      • Sean's avatar
        Sean
        Community Champion
        9 years ago

        Well I know you can't place a Measure in the Legend! What is Object?