This idea came up purely from a client requirement, and by implementing it I thought wow, this actually has many applications. It’s also not that difficult to implement in Power BI.
I know this happens everywhere in organizations, so I’m sure you can relate, but have you ever created a PowerPoint presentation and then had to fill in some space with commentary that no one likely will read or remember after the meeting you go to?
The best thing about using this technique is that you will always have a record of the commentary and you can dynamically refer back to it if you want to know why something happened in the past. It also makes people much more accountable for what commentary they write. Maybe that’s a good thing, maybe bad – it depends how your organization operates. Accountability can sometimes be a slightly dirty word within organizations.
Anyways, this is a great technique that works mostly with the data model. So you need to understand how that all works well, but there’s many ways you can swing this, so as you’re reviewing it, certainly think about other types of filters you could place on your data tables.
Any thoughts on how you could apply this? Let me know in the comments.