How to show comments/annotations on chart?

[abeiswinger]

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.

[ankitha]

Is it possible to have annotations persisted instead of appearing only when hovered. Similar to this With annotations | Highcharts.com

[v-ljerr-msft · Accepted solution]

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. 

Regards

[TomMartens]

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]

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

Hey,

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

Regards

[Militambe3171]

I am facing same issue, can you please explain calculated column with an example