Forum Discussion

abeiswinger's avatar
abeiswinger
Helper I
9 years ago
Solved

How to show comments/annotations on chart?

I have specific data that may or may not have comments.  Right now, I'm using a separate visual (table) to show the comment text but I would like it to show in the annotation bubble that appears when data is hovered over.  Is this feature available?

 

Purple arrow is showing my comments,

Red arrow is showing where I would like to comments to appear when certain months are highlighted or filtered.

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi abeiswinger,

     

    Have you tried the solution provided by TomMartens above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

     

    If you still have any question on this issue, feel free to post here. :smileyhappy:

     

    Regards

6 Replies

  • TomMartens's avatar
    TomMartens
    Super User
    9 years ago

    Hey,

     

    you can create a calculated column that "pulls" the comment from your separate "comment" table into the table that provides the xaxis for your bar chart.

     

    After doing this, you can drag the column to the tooltip bucket of your barchart and the comment will appear in the "annotation bubble".

     

    If you need further assistance by creating the calculation it would be helpful, if you would describe your table structure and maybe you could also provide sample data.

     

    Hope this helps

    • abeiswinger's avatar
      abeiswinger
      Helper I
      9 years ago

      TomMartens

       

      Hi Tom, thanks for your reply - I'm not sure how to create a calculated column to pull the data from the column table.

       

      The datasource is an excel spreadsheet that looks similar to this:

      Column A = City

      Column B = Month

      Column C = Department

      Column D = Planned budget

      Column E= Actual budget

      Column F = Difference between planned vs. actual

      Column G = Comments (why it was over/under budget)

      • TomMartens's avatar
        TomMartens
        Super User
        9 years ago

        Hey,

         

        please provide a link to an excel file on onedrive or sharepoint, that contains your sample data.

         

        Regards

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    Hi abeiswinger,

     

    Have you tried the solution provided by TomMartens above? Does it work in your scenario? If it works, could you accept it as solution to close this thread?

     

    If you still have any question on this issue, feel free to post here. :smileyhappy:

     

    Regards