Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

Show only specific rank from table

Hi everyone,


I'm rather new to Power BI and was wondering whether there is function to only show a specific rank of a table based on a measure.

E.g. I want to create a podium with 1st 2nd and 3rd place (based on a measure that counts the race points) and need visuals for each place. 


What would be the measure to only show 'Williams' on a Card Visual?


Thanks in advance!



Rank = RANKX(

View solution in original post

Super User
Super User

You can use a measure which returns a number as a filter, so you could use your Rank measure. Add the Name column to the card visual, then add Rank as a filter to show only when the value is 3.

I can not filter based on a measure. It won't let me click anything, eventhough it looks like I should be able to click the dropdown menu



make sure that the Format of the Rank measure is set to Whole Number



It is, but I can still not use it as a Filter

at what level are you applying the filter, page or visual? because it will only work at visual level. SQL BI have an interesting article on measures as filters

I am applying the filter at visual level. Is it possible to get a calculated column for the Rank Function instead of a measure? 

If so, what would it be if thats my measure?

Rank = RANKX(

I think that that code would also work for a calculated column, but bear in mind that it will not be affected by any slicers or filters, so you could not for example choose a date range

Unfortunately it does not work..




Rank = RANKX(

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors