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

[@sudeepsaxena8023]

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?

[@Moon_Rise6393]

Superb dude You're becoming my superhero of BI. You're making content very easy and simple. Thankyou Buddy 🎉

[@garryelsdon6296]

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

[@jozsefkotai8203]

The best opportunity for TOPN calculation, Thanks !

[@manjumaddur3097]

Thank you very much sir, I was struggling to get this solution. It helped me a lot. I subscribed now.

[@ankitseth100]

Thanks for the video,I am facing one issue that when I select 10 and bottom as slicer then it giving 9 value in table. For top it is working fine. For all the bottom selection it is giving one less value in visual. Can you help on this please.

[@yiubili1]

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?

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

[@ektasingh8962]

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

[@AlexanderCortes210486]

Thanks you so much Fernan, what a way of using Rank. great video sir.

[@ProgrammingAdventure]

Thanks for this content, so if I want to give a slicer of change value and according to that value parameters ranking changes the basis on that.

[@MamathaB-i3d]

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

[@jujufina1]

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

[@skylight1order2008]

What a great example ! Thank you for that !

[@manojchavan6917]

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

[@taotony851]

Hi, is there any reason why you picked CONTAINSSTRING to check which value is pick in breakdown? Would this become more efficient than SWITCH stament?

[@abdulmuhaimin6872]

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

[@pthapa55]

Awesome example, thanks!

[@Technowolfopedia]

When I add Months to Columns I get some Blank rows plus the TopN Selected. How to I filter Out the rows were the TopN is not Selected.

[@emadkhalifa-r7q]

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

[@ngontran]

Great tutorial 👍

[@SujathaS-sx3kg]

Can I use switch() instead of if in return statement

[@rishikeshshanbhag3112]

Can you please also tell : 1.how to add a subtotal there as it shows total of entire database. 2. I wanted to show that subtotal as a percentage of the total for that period, so any suggestions?

[@tinaflemons263]

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

[@a5r6abdulrehman]

How to handle different measure in this formula here you use dimension "category", and "product", how to handle if we want to know switch between measure like TopN account to sales, cost, expenses

[@abeybrams2366]

Very important and helpful video

[@karthikkumar3854]

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

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

[@jodyswanson7197]

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?

[@biwithmina7066]

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?

[@datalab365]

Thanks

[@christinachapman9595]

Great video! Thanks! Are you able to use ranking based on subtotal in a Matrix? (Ex. shows customer sales per month for the 12 months and then total sales)

[@krishnanandhk3516]

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

[@rajchin1220]

Yes correct any solution for this problem

[@sushreesangeetajena7646]

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

[@abdulmuhaimin6872]

Hi do you found any solution?

[@codecimages5963]

Hello! How should it be when you want to get top 10 per week?

[@WUL1234567890]

Hi, the measure is working with Top & Bottom selection for dynamic legend, but it is not working if I do not need that Top & Bottom. Is there any reason and how can I fix it? Thank you

[@SujathaS-sx3kg]

Can you explain with switch function for more than two conditions

[@orthodoxreview8490]

how to make these filters to only work with one graph. for example, if I set this filter to only work when these filters are selected then by default shows all. It should not be affected nor these filters affect rest of the visualization

[@ymohamed3154]

Interesting. Thanks

[@Motivational_Greek]

Thnak you

[@MuralidharMohapatra-s5y]

Very good Video. but here Total is showing as total number of all the product instead total of top n product. Please help on this

[@LeeH-p4v]

what if there is another filter --> date in the visual?

[@julie_chen]

Great 👍

[@mike40545]

Nice Vid, but why there is not total for the Bottom-Values?

[@mogarrett3045]

well done

[@sushiheartt]

my ASC is not working. when i click Bottom no data is showing :(

[@prashiksorte5028]

would you make a another video on the same topic but the only difference is that breakdown by (city,state,country) with showing only top N dynamic ranking

[@parikshitkorekar650]

Why are the totals in Top Category Same and why are the total in Bottom Category not showing? Please help me

[@NiteshOjha-e2t]

how to do it with clustered column chart

[@debduttaroy3414]

Hi Fernan.. I hv a requirement where my page has multiple slicer with multiselect , one horizontal bar graph for which I dont want to display sales_percentage for those countries below 5% and want to group those as Others.. X axis - sales-percent Y axis - country

[@lakshmikandha1604]

why total ranking is not calculated when you change filter

[@Dimples-hc3te]

Great video, but the totals are incorrect -- they are not dynamic

[@Hanarhipc9777]

Easy to solve, just filter table to show items only when ranking isn't null

[@SSM_33]

Damn bro

[@a5r6abdulrehman]

How to handle different measure in this formula here you use dimension "category", and "product", how to handle if we want to know switch between measure like TopN account to sales, cost, expenses

Thanks

[@a5r6abdulrehman]

How to handle different measure in this formula here you use dimension "category", and "product", how to handle if we want to know switch between measure like TopN account to sales, cost, expenses

[@themightyvk]

Thanks