Forum Discussion
Can users leave row-level comments and highlight rows?
Hi pbi_106 ,
Sorry, currently for the report server, only report-level comment types can be added. It is temporarily impossible to allow users to add row-level comments to interact with the report.
If you want to implement this feature, you might as well post your idea here. If there are a lot of votes, Microsoft will officially add this feature in the next update, hope it will help you.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
this would be simplier in the service but since I have kind of the same requirement I came up with this rather inconvenient solution - but it works.
You need to have a unique ID for each row. Then use a tool like Sharepoint/Master Data Services or Excel for data insertion. It depends on your security needs.
My setup:
I have a job running that inserts new ID's and other data into the MDS database. In MDS users then can add comments to each ID.
Power BI then loads the data from MDS and displays the comment.
I'm testing also some security enhancement, like a user can only comment certain ID's, like all rows where customer = 'Customer A'. Another case would allow a user to select an ID from a list and add a comment, but can not see other comments.
You can, of course, also use another tool like MS Forms or as mentioned above Sharepoint or Excel, it all depends on your desired security level.
This would also work with highlighting.
I know it is hideous, but it's better than nothing.