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
The INTERSECT function in Power BI is an advanced table function and to understand how it works, you will want to get much better at understanding virtual tables. Virtual tables are a key concept when utilizing DAX measures within Power BI. What the INTERSECT function does specifically is that it allows you to – within a
I have another really unique insight to showcase to you in Power BI today. This is unique not only in the actual insight but in terms of how we can return a text value inside a Power BI table. The function that enables us to do this is SelectedValue. This particular function is really powerful
We’re going to work through something really unique around Time Intelligence inside of Power BI. This scenario was brought up on the Enterprise DNA Support Forum, where there was a need to compare “like-for-like” within months. In other words, they wanted to compare the first working day in a particular month to the first working
We’re going to review a unique customer insight in this example. Specifically, we’re going to understand how to work out the number of customers who have purchased more than one product. While this might seem like a relatively logical calculation, there’s actually more to it when using DAX. This is a perfect example of how
