DYNAMIC TOP/BOTTOM RANKING using PARAMETERS // Beginners Guide to Power BI in 2023

In this video were going to look at how you can use parameters to create dynamic ranking in Power BI, allowing your users to switch and see their topn or bottomn values, as well as choosing how many to see and change their breakdowns.

-

📣 Get Demo Files HERE

🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.

📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more

🛒 Power BI TEMPLATES and more at our digital shop

❤ Other ways to SUPPORT us

📧 GET IN TOUCH

🤝 SOLUTIONS ABROAD
Hi Power BI fans, my name is Fernan. In 2018 I founded Solutions Abroad to help fellow data enthusiasts learn Microsoft’s tool, Power BI. I’m currently based in London with over 8 years of experience working with data and business intelligence. In this channel I provide educational videos about Power BI including tips and tricks, step by step tutorials, news, and all of it for FREE. I also provide some paid content such as courses, templates as well as consultancy services.
If you like what we’re doing here and would like to support, consider purchasing something or donating through our Patreon, every little penny helps us keep the channel going.

🙏 THANK YOU
Thank you so much for checking out my channel and my videos. You, the community, have been instrumental in growing the channel to where it is now. Hope to see you again on my next video!

#PowerBI #DataAnalytics #BusinessIntelligence

[jozsefkotai]

The best opportunity for TOPN calculation, Thanks !

[jujufina]

Great video! How can we exclude taking blanks and zeros?

[Moon_Rise]

Superb dude

You're becoming my superhero of BI.

You're making content very easy and simple.

Thankyou Buddy 🎉

[ektasingh]

You're really awesome at this!! Great work👍

[garryelsdon]

Excellent thank you very much. This solution may be able assist with another problem I have have.

[sudeepsaxena]

Great video!!!

I have 2 questions which I hope you will answer in one of your coming videos....

1) How can I make Top N work for second layer items in a drill down? Like viewing the Top N states by sale and then by clicking on any of the states, I can make use of the same perimeter to view top/bottom N cities by sales for that particular state?

2) How to show the grand total reflecting values only for the visible Top/Bottom N items?

[skylightorder]

What a great example ! Thank you for that !

[Media_Advertising_Analytics]

Thanks for the great video! How would you advise filtering out items with a "zero" value in specific fields in the rankings?

[tinaflemons]

Awesime. Can you actually show the top and bottom in the same visual?

[jodyswanson]

Hello Fernan, This was a very helpful video! Could you please show us how to create a donut chart to show the top 10 total sales, top 20 total sales, and all total sales > $100k?

[MamathaB-id]

Amazing explanations and very clean codes. Please make more videos on PBI relationships as well

[manojchavan]

This is just amazing, thanks for posting such informative video 😊

[krishnanandhk]

everything works fine but when I add the
year filter as a slicer on the page, the bottom values are not showing

[yiubili]

Thanks for your sharing, really like your walkthrough, please keep the sharing coming. Is it possible to rank when i have multiple measures, like total sales, sales change against previous month, Sales change against previous year, etc please?

[jeremrndn]

Thanks a lot for this video! Now, what if you want to dynamically create this TOP N, but adding a condition "Total Orders > 100" for example? On my side, using the Visual level filter does not work, the TOP N is not dynamic, ending with 3 products instead of TOP5.

[karthikkumar]

Hi, Thanks for the video & Could you pls make a video on COUNT N number of products achieved their target consecutive N months

[abdulmuhaimin]

Do you have any video for dynamically dimension, measurement and filter top/bottom measurement in one visualisation

[emadkhalifa-rq]

what if I have multiple columns ? lets say the product and the category both I want them in the same table and my slider will filter both of them based on my criteria

[biwithmina]

Fernan,
Great video as always, In this video, I noticed that the bottom N does not yield any total value. Can you provide a solution to these?

[sushreesangeetajena]

great video sir, here, you have used total sales to compare, could you please explain how to add more metrics like total profit, total orders, etc