In this post, I want to show you what is without a doubt one of the most compelling visualisation techniques in Power BI.
Never feel you are confined to use just the general visualisation options inside of Power BI (or custom visuals for that matter). You have a significant opportunity to make your visuals even more compelling by using DAX to create dynamic measures.
In this video, I show you how to use what I term as the multi-threaded approach to dynamic visuals.
Creating a dynamic measure through one selection is cool, but what really takes your visuals to the next level is when you thread multiple variables into measures that then determine what is shown inside visualisations.
This is not an easy technique, but it is certainly worth learning and understanding. If you do, you can start applying it in many different ways.
In the demo model in the video, I’ve used the visual interactions to great effect by creating three layers within the report page to really drill into key data and information in distinct regions.
My main goal with this video is really to inspire you about what you can achieve within Power BI. It is seriously unlimited. While you have to learn a lot about all areas in Power BI to really get it going well, once you do, the visualisation and analytical work can be outstanding.
Good luck with this one – I’d recommend learning this technique well. You won’t regret it for a second.