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 eac...
Need Help
chrisgehm's avatar
chrisgehm
Helper III
9 years ago

Object is text, but I have other vales apart amount to show.

There are 3 numeric values, per month, so I'm a bit lost with this...

Sean's avatar
Sean
Community Champion
9 years ago

Can you post some sample data? I think the first sample you posted was oversimplified.

  • chrisgehm's avatar
    chrisgehm
    Helper III
    9 years ago

    Sure Sean,

    I'v got this table, with 3 amounts:

     

    What I need to do, is to show in a chart graph, per month the 3 amounts.

    And when I step over the chart, per month, I need to show whici object is in that month.

    • Sean's avatar
      Sean
      Community Champion
      9 years ago

      chrisgehm  First Unpivot the Data as shown here...

       

       

      Then You'll need this MEASURE

      Amounts 1,2,3 = IF ( HASONEVALUE ( Table1[Object] ), CONCATENATEX ( Table1, Table1[Value], ", " ) )

      This will allow you to create the Chart and also the Matrix shown below.

      Here's the result :smileyhappy:

       

       

      • chrisgehm's avatar
        chrisgehm
        Helper III
        9 years ago

        Seems the correct answer, but when I try to unpivot table, nothing apears: