DYNAMIC TOPN Ranking using PARAMETERS / Let Users Control Top Values / Beginners Guide to Power BI

In this video were going to go through how you can make your TopN values dynamic using parameters.
-
🚩 Get Demo Files here
bit.ly/3dJE2O7
👍 Become a Patreon to support the channel and get free perks!
/ solutionsabroad
🛍 Get exclusive templates built using best practices here
ko-fi.com/solutionsabroad/shop
solutionsabroad.co.uk/store
❤ Other ways to support
ko-fi.com/solutionsabroad
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of KZbin.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence

[@martinfidalgo8300]

You cant imagine how your videos have helped me in my current job, you are a lifesaver! Thank you, keep up with the good content!🎉

[@etherlords88]

Fantastic! 🎉🎆 Always love your videos! Always to the point, useful ones and very informative!

[@bidhanry9740]

One can find so many videos related to dynamic top n, but this one is the best till date on the internet

[@user-vx4qt1vu3q]

I was looking for that content for a long time! Thank you!

[@Paktvlounge]

This was amazing. Thank you very much for making this tutorial.

[@RobertKirakosyan]

Very good work but when you change the parameter, the total does not change, how to fix it?

[@humzaihsan4403]

Right on the spot what i was looking for.

[@krupalibusa1143]

Thanks for making this. Good Explanation

[@deepalitate]

This tutorial helped me a lot.

[@distrilanalytics]

Solved alot Questions. Great to learn from you.

[@TrangLuong-f1o]

Thank you so much!

[@vrbaac1641]

Thank you so much for helping me understand this procedure ^^...

[@biwithmina7066]

Fernan, Great video as always, In this video, I noticed that the Total for the top N is the same as the total for the entire table

[@shoaibrehman9988]

Very good stuff mate

[@blakapikin]

Thank your video's. Always very clear when explaining. I have one question. I tried using the parameter for the ranking in my dashboard. When I place the rank on 5 for example, I only get 4 results in my table. What can I do to fix this? Or what am I doing wrong.

[@ashokkumarpadmanabhan6483]

Very Interesting Demo !!!

[@pl4195]

top N and by different categories. can we do that as well? say two parameters, one is top N , another one is by country, by product, by entity etc.

[@b.5057]

amazinng explanation!

[@amoldeshmukh5350]

Awesome content.

[@abdulrehman56]

great work

[@yhlim4931]

the total is not dynamic

[@sparshkapoor8517]

Awesome!!

[@jaldaamol46]

Hi @Solutions Abroad, I like this tutorial. But, If you absorb Total of Top 5 and total of Top 10 are same, they're not changing. How to get the total as well, as per for TopN?

[@aydeediaz2307]

Hi thanks! What if a want to see the top 10 Products but also have a column named region to see from which region they are, but not giving me top 10 for each one?

[@itdemos-jr7tv]

Perfect! however I tried to add another column in legend and it didn't work, so to use your example I wanted to show Countries, categories and use the rankx over that

[@madhavimundada3383]

The total doesn't change with the parameter value. How can I change that?

[@vishalgandhi4279]

Thanks❤

[@sreemalapal]

Hi..The total amt in the table is not reflecting correctly. Eg. For Top 5 countries, the total Sales should be 848,171.48. However, as per the table, it shows 13,54458.59. How to correct this? ,

[@KhaiNguyen-yh9mt]

You need to insert the Top Value Values into the filter and change the criteria to Is Not Blank. That way, the thing will filter through and have a dynamic total

[@millyq3407]

that's great! thanks for the videos. Please i have a question: when i do that for top and bottom, it seems to rank well, I actually set so that it will just rank those category with have a value , however there are some that are empty, and so the ranking works fine for top but then bottom will only display the range i selected minus 1, meaning that i select Bottom with a range of 3, so Bottom 3 categories, it shows me all categories that rank 1 and 2 but not 3 even is correctly ranked, and is not ranking the categories that have no values. Any suggestions? the top 3 categories display fine but not when i select bottom. the formula is the same except for the ASC and DESC part

[@shivameduri9443]

After applying If conations the rows are not being filtered. i am able to see all the countries with the blank values & the TOP N values with the sales values

[@BestICan]

Thanks!

[@SolutionsAbroad]

Thanks for the generosity Randy, appreciate it!

[@prachikanoongo1221]

Does this Parameter changes value in other visualizations too?

[@DanielS-ef1oz]

What to do to have correct sum of top selected in the table?

[@user-ph2pb9tz7j]

there is issue here that the total of table is not changed

[@MLissieMusic]

That was great mate. I do have a question. How can I change the labels and color of a graph 📊 as I drill down into it?

[@SolutionsAbroad]

Thanks for watching! It sounds like you need to use conditional formatting to highlight your bar chart values! I covered it in a separate video if you're interested

[@MLissieMusic]

@@SolutionsAbroad great to hear. It would be good to know the link or title of the video mate.

[@SolutionsAbroad]

@@MLissieMusic Here you go! kzbin.info/www/bejne/pmmbhZR7jZ17Zqc Just note that it's one piece of the puzzle so you'll need to think about how to integrate this with your drilldowns, hope that helps!

[@travelkare]

Hi, Bought silver membership, still not able to download demo files of this video. Please fix it soon

[@FamilyPlays22]

The sum of Total values of topn are wrong, how can I fix?

[@pralhadgujar9113]

Hi, I tried the same dax formula but not working, every row shows rank 1.

[@Mikel526]

Very insightful How can you make this work with a Card visualization? Tried, and the Card always provides the total regardless of N selected

[@SolutionsAbroad]

Hi there, depends on how you want to show your data on your card, because card needs to show summarised values. You can look at using multi row cards which should work

[@Mikel526]

@@SolutionsAbroad thanks for your reply! :) I’d like to ahow the totals of the totals of the top N E.g the total sales of top 5, if i change value of N to top 3 the card will change to total sales of top 3

[@nidhisingh4973]

@@Mikel526 Did you get the solution for this? This is not working with Multi Rows Card as well.

[@nidhisingh4973]

​@@SolutionsAbroad This is not working with Multi Rows Card as well. Can you please let me know the way to show this in card visual? Card Visual is working fine for TOPN function.

[@kamilwiecawski8634]

Great video but doesn’t work in my case 😢. Rank does not rank my values.

[@alphabarry3448]

Hi is there someone who can help with ranking sales by month?