Tag: Conditional Formatting

Power BI Conditional Formatting For Chart Visuals – What’s Possible?

I’m going to talk about how the Power BI conditional formatting feature can take your reports to the next level. It’s a really useful feature, but not a lot of people use it mostly because this function is buried under Power BI’s other tools. The conditional formatting feature in Power BI holds a lot of

Continue reading

Custom Conditional Formatting Techniques In Power BI

There have been some relatively recent updates when it comes to creating custom conditional formatting inside your Power BI tables. For this tutorial, I want to highlight the various things you can do with this new feature. The conditional formatting in Power BI allows users to specify customized cell colors based on cell values, other values or

Continue reading

Averages Per Customer Transactions – DAX in Power BI

What I want to demonstrate in this tutorial is how we can calculate the average amount of sales, profits, or transactions per certain dimension inside of DAX in Power BI. In this particular example we’re going to look at it from a customer’s perspective. We’re going to try and analyze what the average sales are

Continue reading

Find Top Customers Using RANKX In Power BI

Power BI is an amazing analytical engine! In this blog post, I’m going to show you how you can find your top customers – not just as static numbers, but through time and through any time period you could want. This is the power of DAX combined with the data model at its best. I

Continue reading

Power BI Trend Analysis: Are Margins Expanding Or Contracting?

In this blog post, I will be diving into a relatively specific insight by conducting a Power BI trend analysis. By walking through exactly how I got there, you will learn so much about what you can do with Power BI and DAX. I really dive into this concept of measure branching, which I love

Continue reading