Forum Discussion

sgupta22's avatar
sgupta22
Helper II
1 year ago
Solved

Comments on individual data point or visual

Hi Everyone,

 

Is it possible to add comments to an individual data point or individual visual in Power BI Desktop?

 

Thanks for your help! 

  • Hi sgupta22 

    It's not natively available within Power BIfor data points, but there is a general comment feature for a dashboard or report .  But you can add comments in an Excel or SharePoint List and then show these comments in a Tooltip when you hover over the data. If you have the licence, you could build a Power App to collect the comments and even embed the Power App in the PBI Report

    But the key here is structuring the Excel/SharePoint List correctly so that the comments show on the correct data.

     

    You will need to think about the following possible dimensions, change to whatever is in your dataset

     

    • Date
    • Product/Country/ etc..

    Load the data into Power BI, create relationships with your dimenesion tables. Create a tooltip page for the Comments

    Here is a good video explaining. You don't need the visual they are promting to achieve what you need https://www.youtube.com/watch?v=MrpFQSB8NbY 

     

    Joe

2 Replies

  • Joe_Barry's avatar
    Joe_Barry
    Solution Sage

    Hi sgupta22 

    It's not natively available within Power BIfor data points, but there is a general comment feature for a dashboard or report .  But you can add comments in an Excel or SharePoint List and then show these comments in a Tooltip when you hover over the data. If you have the licence, you could build a Power App to collect the comments and even embed the Power App in the PBI Report

    But the key here is structuring the Excel/SharePoint List correctly so that the comments show on the correct data.

     

    You will need to think about the following possible dimensions, change to whatever is in your dataset

     

    • Date
    • Product/Country/ etc..

    Load the data into Power BI, create relationships with your dimenesion tables. Create a tooltip page for the Comments

    Here is a good video explaining. You don't need the visual they are promting to achieve what you need https://www.youtube.com/watch?v=MrpFQSB8NbY 

     

    Joe

  • christinepayton's avatar
    christinepayton
    Most Valuable Professional

    The mechanism to do this right now is via the canvas apps integration, if you want it to be available on the report right away you need to use something that supports direct query. There's tutorials in YouTube for it if you search for "Power BI writeback".