Through this example I’m going to show you how you can dynamically adjust the size of your visual. And in this case, we’re going to do it via the result ranking. This is a really powerful technique that you can utilize in Power BI. Never think you are limited to the standard ‘out of the
Category: Business Intelligence
As soon as you start developing a few Power BI models, you’ll very likely run into this problem … You have two dates in your fact table (your transaction table) and you can’t place two relationships between your date table and the other table. You might even have multiple dates, like entered date, ordered date,
Working out your profit margins in Power BI with a basic data set can seem like it requires a few steps. Maybe you think you need to use calculated columns to get the result. Well, you certainly don’t need to do that – there is a much simpler way. Using measures, you can start with
Quick measures in Power BI is a fantastic feature that can increase the speed of development immensely. Here, I review how you can start using them and I look at the many considerations of actually implementing them. Quick measures isn’t perfect but it’s being updated all the time. The Power BI team have made a
The DATEADD function is by far my go to time intelligence function in DAX at the moment. Mainly because of it’s immense versatility to generate time comparisons over a range of different time frames. This detailed video will go through all the various aspects of how to set up time comparison analysis with this function.