Future-Proof Your Career, Master Data Skills + AI

Blog

Blog

# Create Automated Lists Based On Ranking Calculations in Power BI

by | 3:00 pm EST | January 26, 2018 | DAX, 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 particular metric. You may watch the full video of this tutorial at the bottom of this blog.

There’s a bit to this one, but if you can learn how this works then there are many different ways you can take this across other dimensions in your data sets.

In this example I want to see my top clients in sales, profits, and profit margins, AND I want to be able to do it dynamically, utilizing the power we have in our data model in Power BI.

So I want to be able to also filter by any time frame, and in this example, I use quarters, and quarters and years.

On top of this, I also want to integrate some ranking logic where I can create a filter which showcases only my top 5, 20 or 50 clients.

By combining all of these techniques, you get this really powerful visualization in your reports where you can really drill into or back out of a particular insight or particular analysis based on any of these metrics that we integrate into our logic.

Try and get your head around each individual part of the formulas I implement here.

Following that, you can begin to get an understanding of how to integrate many DAX formulas all together, because one DAX formula in isolation can only do so much.

Combination measures by utilizing the ‘measure branching’ technique I talk about a lot is how you can create some compelling visualizations and analysis in Power BI.

I cover measure branching in depth across a range of example in the Solving Analytical Scenarios module at Enterprise DNA Online. Check out this course to discover more.

All the best with working out this insight.

## How to Calculate Age in Excel: 5 Best Methods Explained

Looking to calculate age in Excel? Well, you're in the right place. Whether you need to find the age of...

## Funny ChatGPT Prompts: 20 Hilarious ChatGPT Ideas

In a world where technology continues to amaze us, we have now arrived at the point where we can have a...

## How Many Rows Can Tableau Handle?

Are you dealing with a large data set? Are you wondering how many rows can Tableau handle efficiently?...

## How to Update Tableau in 4 Quick Steps

With frequent updates and new releases, Tableau continues to evolve and improve its functionality. To...

## Power BI Slicer Search: User Guide With Examples

Ready to get started with the Power BI slicer? This feature will allow you to filter and slice your...

## What is Context Filter in Tableau? How to Apply and Set

One of the powerful features of Tableau is its ability to allow users to interact with data...

## How to Number Columns in Excel Automatically: 5 Quick Ways

In Excel, numbering columns is an important and straightforward process that can help you organize and...

## How to Make a Logo Transparent in PowerPoint: Quick Guide

A transparent logo can be a powerful tool in your branding arsenal. It allows your logo to seamlessly...

## Excel Waterfall Chart: Guide to Create, Design & Impress

Have you heard of an Excel waterfall chart but are unsure how to create one and make it stand out?...

## Tableau Tooltip: A Design Guide for Customization

Are you ready to use Tableau tooltips to level up your visualizations and make them more insightful and...

## What is a Set in Tableau and How to Create Them: User Guide

Are you getting started with Tableau and looking to create a set? Well, you're in the right place. In...

## How to Alternate Colors in Excel: 3 Top Ways Revealed

Knowing how to alternate colors in Excel can be a game-changer; there's little more satisfying than a...