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

[@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!🎉

[@bidhanry9740]

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

[@BestICan]

Thanks!

[@SolutionsAbroad]

Thanks for the generosity Randy, appreciate it!

[@Paktvlounge]

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

[@Sandra-b4c1r]

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

[@yhlim4931]

the total is not dynamic

[@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.

[@RobertKirakosyan]

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

[@HealingHooman4616]

Just pasting the reply someone has posted in other comments "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"

[@TSmitty360]

@@HealingHooman4616 This doesn't seem to work either. Tried with the 'Top Values'[Top Values] and the [Top Values Value]. It does not change the table total for me.

[@nouranashraf-e4l]

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

[@humzaihsan4403]

Right on the spot what i was looking for.

[@Technowolfopedia]

Hi I have an issue. The rakink and top issue are working as expected, But when Months in columns I get some blanks totals how to I filter it out

[@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

[@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

[@madhavimundada3383]

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

[@krupalibusa1143]

Thanks for making this. Good Explanation

[@deepalitate]

This tutorial helped me a lot.

[@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

[@HealingHooman4616]

@@KhaiNguyen-yh9mt Genius :)

[@TSmitty360]

@@HealingHooman4616 did that work for you? It did NOT work for me.

[@ashokkumarpadmanabhan6483]

Very Interesting Demo !!!

[@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.

[@distrilanalytics]

Solved alot Questions. Great to learn from you.

[@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?

[@prachikanoongo1221]

Does this Parameter changes value in other visualizations too?

[@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!

[@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

[@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

[@FamilyPlays22]

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

[@vrbaac1641]

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

[@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.

[@etherlords88]

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

[@TrangLuong-f1o]

Thank you so much!

[@DanielS-ef1oz]

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

[@amoldeshmukh5350]

Awesome content.

[@b.5057]

amazinng explanation!

[@vishalgandhi4279]

Thanks❤

[@sparshkapoor8517]

Awesome!!

[@travelkare]

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

[@abdulrehman56]

great work

[@pralhadgujar9113]

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

[@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?