Tag: SWITCH True Logic

Power BI Dynamic Ranking By Group

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

Continue reading

How To Create Automated & Dynamic Power BI Reports

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

Continue reading

Power BI Reporting Templates Expanded – Power BI Visualization Concepts

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

Continue reading

Budget vs Actual vs Last Year – Financial Reporting Tips

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

Continue reading

How To Use SWITCH True Logic In Power BI

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

Continue reading