Tag: Ranking

Advanced DAX For Power BI: Implementing Ranking Logic Across Unique Insights

Here, we’re going to dive into Advanced DAX in Power BI. The idea behind this tutorial is to show you how we can get to a very unique insight with Power BI, but do it in an intuitive way. In this example, I’m going to focus in on margin growth in the sales of an

Continue reading

Discover Unique Insights Using Power BI TOPN Function

In this video, I wanted to find an insight that was really unique, and hugely valuable for business. Here, I used the Power BI TOPN function. I wanted to know the best-selling day for every single product. Not only that, I wanted to be able to look dynamically into any store and analyse the best-selling

Continue reading

Using Dynamic Visuals On Ranking Based Parameters In Power BI

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 in Power BI. We’re going to create dynamic visuals containing our top 10 customers for specific products. This is a really powerful technique that

Continue reading

Creating Dynamic Ranking Tables Using RANKX In Power BI

Creating Dynamic Ranking Tables Using RANKX In Power BI

I really like using this unique technique inside of Power BI to create dynamic ranking tables. What do I mean by Dynamic Ranking Tables? Dynamic tables showcase a range of information dynamically in a table, but the information that are showing are based off a specific ranking on a singular calculation. In this particular example,

Continue reading

Show Only Top Or Bottom Results Using Ranking Formula Techniques – Power BI & DAX

In this tutorial, we are going to dive into on how to utilize the RANKX function effectively in Power BI. Sometimes you don’t want to show all of the results from your data in your visualization. Sometimes you only want to see the top or the bottom results, for example the top five or the

Continue reading