Dynamic ranking in Power BI can be tricky if you don’t fully understand how it works. You might think that you got the formula right, but then you’d be surprised why you’re not getting the correct results. The key is to really understand the context that you’re working on and simplify your formulas. Knowing your
In this blog, I go over a really incredible development technique and concept on creating dynamic Power BI reports. This is actually taken from a session from a members-only event that I put on through Enterprise DNA, which was centered around financial reporting templates. In this tutorial, I want to go deeper into dynamic reporting
In this tutorial, I dive into how to customize Power BI reporting templates efficiently. When you create tables inside Power BI, you can’t format or design them exactly the way you want them to be. You can only use the default order or sequential order that Power BI generates within the table, which can be
Here, I’m eager to demonstrate how you can dynamically represent financial information in a compelling manner using Power BI. Now, it’s very easy to study budget vs actual vs last year inside Power BI because of its immense improvement in terms of financial reporting. With this advancement, you can readily evaluate performance and forecast future
When utilizing SWITCH/True Logic inside Power BI, you really do open up this huge expanse of analytical opportunities. In this tutorial, I’ll run through how you need to set up your formulas when using the SWITCH function. This will enable you to find, discover, and visualize many different and interesting insights within Power BI. There
