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

Подписаться 46 тыс.

Просмотров 26 тыс.

50% 1

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
bit.ly/3dJE2O7
🔍 Looking to get started in data? Check out this COURSE to get the essential skills you need. No experience required.
solutionsabroad.thinkific.com/
📰 Sign up to our FREE Weekly Newsletter for Power BI news, community updates and more
solutionsabroad.co.uk/newsletter
🛒 Power BI TEMPLATES and more at our digital shop
solutionsabroad.co.uk/store
ko-fi.com/solutionsabroad/shop
❤ Other ways to SUPPORT us
/ solutionsabroad
ko-fi.com/solutionsabroad
📧 GET IN TOUCH
Website: solutionsabroad.co.uk/
Email: fernan@solutionsabroad.co.uk
LinkedIn: / solutionsabroad
Facebook: / solutionsabroad
Instagram: / solutions_abroad
🤝 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

Опубликовано:

3 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 55

@ektasingh8962 3 дня назад

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

@jozsefkotai8203 Месяц назад

The best opportunity for TOPN calculation, Thanks !

@Moon_Rise6393 5 месяцев назад

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

@manojchavan6917 9 месяцев назад

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

@skylight1order2008 7 месяцев назад

What a great example ! Thank you for that !

@garryelsdon6296 4 месяца назад

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

@pthapa55 Год назад

Awesome example, thanks!

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

@sudeepsaxena8023 4 месяца назад

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?

@user-qq1jb9bd7r 7 месяцев назад

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

@ymohamed3154 Год назад

Interesting. Thanks

@ngontran Месяц назад

Great tutorial 👍

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

@yiubili1 6 месяцев назад

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?

@datalab365 Год назад

Thanks

@abeybrams2366 4 месяца назад

Very important and helpful video

@tinaflemons263 Год назад

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

@Motivational_Greek 4 месяца назад

Thnak you

@mogarrett3045 Год назад

well done

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

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

@julie_chen Год назад

Great 👍

@krishnanandhk3516 6 месяцев назад

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

@karthikkumar3854 Год назад

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

@comptegmail273 Год назад

Hello sir, would you considering making videos about integrating Machine Learning algorithms in PowerBI ? I have been watching you for a long while

@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

@user-fk9kf9nz9q Год назад

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

@rishikeshshanbhag3112 2 месяца назад

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?

@codecimages5963 4 месяца назад

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

@AdityaBhatt-fz1wn Год назад

Hey guys , good video but there can be a case where we might blanks(many) in the data say we have 25 blanks and we are going for bottom n analysis so entering 5 in rank will not work since 25

@ahmedyasser9639 2 месяца назад

how to use it please ? i have this problem :(

@abdulmuhaimin6872 9 месяцев назад

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

@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 9 месяцев назад

Hi do you found any solution?

@SujathaS-sx3kg 5 месяцев назад

Can you explain with switch function for more than two conditions

@orthodoxreview8490 2 месяца назад

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

@NiteshOjha-e2t День назад

how to do it with clustered column chart

@SujathaS-sx3kg 5 месяцев назад

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

@mike40545 Год назад

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

@user-on5xz5ep9r 9 месяцев назад

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

@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

@WUL1234567890 9 месяцев назад

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

@user-fx8wu6yt5v Год назад

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

@lakshmikandha1604 7 месяцев назад

why total ranking is not calculated when you change filter

@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

@parikshitkorekar650 9 месяцев назад

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

@SSM_33 Год назад

Damn bro

@Dimples-hc3te 6 месяцев назад

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

@dukgdv5223 4 месяца назад

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

@themightyvk 11 месяцев назад

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

Год назад

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