Tag: RANKX

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

Create Automated Lists Based On Ranking Calculations in Power BI

You might find a situation where across a range of different metrics you actually want to show the TopN of something. In the example I run through in this tutorial video, I’m going to show how dynamically we can place a filter on our set of clients that is determined by the ranking in a

Continue reading

Change Your Visuals Size By Ranking Logic in Power BI using DAX

Have you ever wanted to create a visualization which changes based on any ranking selection you could make? In this video, I show you exactly how to do it. Think of a scenario where you want to showcase your top 20 clients. Pretend you’re in a meeting saying, “These are the clients that are contributing

Continue reading

Detailed Ranking Example Using DAX in Power BI

Power BI is an amazing analytical engine! Today 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. In this example I

Continue reading

Make Your Visuals Dynamic Based On Rankings 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. This is a really powerful technique that you can utilize in Power BI. Never think you are limited to the standard ‘out of the

Continue reading