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 II
Helper II

Dynamically show only the top values of a table based on two columns

Hi all,

I am working on a table that shows records by date and subgroups. It currently looks like this:


Users will use the slicer as they wish to show records up until a certain date. We want to show only the rows with rank = 1 and the highest rank stages. 

So in this example, if the user wants to see results before February 15th, he should see only the first row. If he wants to see results before the 17th but after the 15th, only the second row.


I thought this could easily be done with top n in the filter, but it can't be used twice. I suppose I need to write a measure that bases on the column rank stages to show only the highest value of it, while I use the top n filter on the column rank. But I don't understand how this measure can work.

I looked it up, none of the use cases I found in the forum match the issue at hand. I am at a loss as how to solve it.

How should I approach this? Please help me out 🙏



Helper II
Helper II

Unfortunately this doesn't do the trick with ties in dates. I have written a measure that I thought would do the job nicely within the visuals.

Have a look here:



The measure tie looks fine in its result. But we still have two lines appearing. Why?



because they rank the same.  Add a small random value to each of them to break the tie.

Super User
Super User

Change the slicer type to "Between"

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.

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