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

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

  • Militambe3171's avatar
    Militambe3171
    Frequent Visitor
    7 years ago

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