Inforiver

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

10 key considerations for a commentary solution in Power BI 

by Chandra Vadana Rajamohan | Nov 11, 2022 |

In an earlier blog, we explored how comments are different from notes, and how many Power BI ‘commenting’ solutions in the market today are in fact just implementations of ‘notes’.  

Power BI does provide a native, true, out-of-the-box commenting capability. It supports report-level and visual-level commenting including @mentions and collaborative conversations. However, data level commenting is not possible.  

Data-level commentary is very common in real-life scenarios. If you are looking to implement true data-level commenting, you need to consider the following characteristics: 

  1. Notes vs. Annotations vs. Comments 
  1. Data-level comments 
  1. Footnotes 
  1. Replying to comments 
  1. Triggering email notifications 
  1. Sending commentary digests 
  1. Word-wrap for long comments 
  1. Task assignment & tracking through comments 
  1. Commentary audit log 
  1. Exporting & writing back comments 

Without holistically looking at the above, choosing a solution based on a limited set of considerations would hinder flexibility and ROI.  

***

1. Notes vs. Annotations vs. Comments 

The first consideration is to evaluate what you need – not just today, but for the long run, and evaluate whether the solution can support it. In our opinion, when report users say they need the ability to ‘comment’, they can mean one of the three types – notes, annotations or comments.  

Notes: Notes are static text added to a data point or visual to give some descriptive details. Observe that notes do not have options for reply and do not capture time stamps. 

Notes

Annotations: Annotations provide context to enhance your storytelling experience with textual call outs and drive attention to important areas. It can be used to highlight a part of a text and add comments/notes on top of it. Annotations are very similar to notes but they are visibly displayed by default. 

Annotations in the below small-multiples chart facilitate compelling data stories. 

Annotations

Comments: Comments allow multiple users to converse over a common thread through replies and mentions. User details and timestamps are accessible, and instant notifications are sent on mentions and replies.

Comments

Ideally, look for a solution that can support all the three capabilities. Do not go by how the vendors call it, as these terms are often used interchangeably.  

2. Data-level comments 

A key requirement for a commenting solution is to deliver the ability to comment at the data-level – which could be at the cell, row, column, row-header or a column-header level.  

An ancillary requirement for such data-level comments is that they must be filterable based on the context. In other words, if the filter or context is modified, they should disappear/re-appear accordingly. Support for rich text styling and formatting options also enhances the user experience.  

Here is an example of cell, row, measure, and category-level comments. 

Cell, row, measure, and category-level comments

3. Footnotes 

Footnotes are an integral part of financial statements and provide supplementary information such as the accounting method used or explanation of important financial results. This is a key requirement for financial reporting use cases.   

Footnotes

4. Replying to comments 

Users should be able to use @mentions to grab the attention of another user and have threaded conversations at a cell, row or column-level.  

Replying to comments

5. Triggering email notifications

The ‘@user’ mention in the comment or task assignment should automatically send an email notification to the user, with a link to the report so that the user can respond to this comment and/or update the report.  

Triggering email notifications

6. Sending commentary digests 

Users should be able to receive periodic commentary digests to quickly analyze the conversations, tasks and exceptions. Scheduling these digests should be out-of-the-box with flexible frequency options and must not require the involvement of IT.  

Sending commentary digests

7. Word-wrap for long comments

Long text comments are common in reports, and it should be possible to wrap them out-of-the-box. 

Word-wrap for long comments

8. Task assignment & tracking through comments 

Use commentary capabilities to assign tasks and track their status right within your Power BI report. Tracking status for comment assignments, using terms such as ‘resolved’, ‘open’, etc. is helpful when you are interacting with multiple stakeholders.  

Task assignment & tracking through comments

Users who only consume the report in reading view and do not have edit rights should also be able to see the tasks assigned to them. 

My Tasks Reading view

9. Commentary audit log 

Tracking changes in the report using an interactive, filterable, and comment-enabled audit log that captures date, time, user details, task status and more is essential for ​data governance. You would know who commented on a specific data point, and when.

Commentary audit log

10. Comments export & writeback 

It should be possible to easily export and writeback notes and comments to Excel and databases. It is not helpful if the notes and comments cannot be persisted outside your report. 

Comments export & writeback

***

Inforiver delivers out-of-the-box and user-friendly notes, annotations and comments to Power BI users using a no-code user experience. Key highlights of the commentary solution delivered by Inforiver are summarized below: 

Commentary solution - Inforiver

Inforiver Charts, Matrix and Enterprise are available in Microsoft Appsource. Get started today!  


Inforiver Logo
IBCS Certified
Power BI certified
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
Headquarters
5920 Windhaven Pkwy, #130
Plano TX 75093
ValQ
xViz
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram