Dynamically Highlight Data Points Based on Slicer Selection!
Sometimes, common Power BI requests can make you scratch your head. Learn how to implement an effective workaround to dynamically highlight data points based on the user selection!
Just recently, I was working on the Power BI report for one of the clients, where one of the requirements was to highlight specific data points in the clustered bar chart visual, based on the slicer selection.
To illustrate the requirement, I’ll be using a Contoso sample database:
To quickly explain: when a user selects, for example, Contoso in the slicer, the Contoso bar should be highlighted by using a different color. As much as this sounds like a very basic and common business request, there is no straightforward solution in Power BI (or, at least, I’m not aware of it:))
However, the client’s wish is (almost) always our command — so, let’s see how this feature can be implemented with a little bit of data model tweaking and leveraging some DAX code.