DYNAMIC TOP/BOTTOM RANKING using PARAMETERS // Beginners Guide to Power BI in 2023
Жүктеу.....
Пікірлер: 53
@jozsefkotai820314 күн бұрын
The best opportunity for TOPN calculation, Thanks !
@manojchavan69178 ай бұрын
This is just amazing, thanks for posting such informative video 😊
@skylight1order20087 ай бұрын
What a great example ! Thank you for that !
@garryelsdon62964 ай бұрын
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?
@user-qq1jb9bd7r6 ай бұрын
Amazing explanations and very clean codes. Please make more videos on PBI relationships as well
@ymohamed3154 Жыл бұрын
Interesting. Thanks
@Moon_Rise63935 ай бұрын
Superb dude You're becoming my superhero of BI. You're making content very easy and simple. Thankyou Buddy 🎉
@yiubili15 ай бұрын
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?
@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)
@ngontran26 күн бұрын
Great tutorial 👍
@sudeepsaxena80234 ай бұрын
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?
@karthikkumar3854 Жыл бұрын
Hi ,Thanks for the video & Could you pls make a video on COUNT N number of products achieved their target consecutive N months
@datalab365 Жыл бұрын
Thanks
@abeybrams23663 ай бұрын
Very important and helpful video
@Motivational_Greek4 ай бұрын
Thnak you
@julie_chen Жыл бұрын
Great 👍
@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?
@mogarrett3045 Жыл бұрын
well done
@comptegmail273 Жыл бұрын
Hello sir, would you considering making videos about integrating Machine Learning algorithms in PowerBI ? I have been watching you for a long while
@tinaflemons263 Жыл бұрын
Awesime. Can you actually show the top and bottom in the same visual?
@abdulmuhaimin68728 ай бұрын
Do you have any video for dynamically dimension, measurement and filter top/bottom measurement in one visualisation
@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
@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
8 ай бұрын
Hi do you found any solution?
@SujathaS-sx3kg4 ай бұрын
Can I use switch() instead of if in return statement
@a5r6abdulrehman11 ай бұрын
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
@WUL12345678908 ай бұрын
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-sx3kg4 ай бұрын
Can you explain with switch function for more than two conditions
@jeremrndn20 күн бұрын
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.
@krishnanandhk35165 ай бұрын
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
@mike40545 Жыл бұрын
Nice Vid, but why there is not total for the Bottom-Values?
@codecimages59633 ай бұрын
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
Ай бұрын
how to use it please ? i have this problem :(
@debduttaroy341411 ай бұрын
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
@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
@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?
@user-fx8wu6yt5v Жыл бұрын
what if there is another filter --> date in the visual?
@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
@user-on5xz5ep9r9 ай бұрын
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
@parikshitkorekar6509 ай бұрын
Why are the totals in Top Category Same and why are the total in Bottom Category not showing? Please help me
@lakshmikandha16046 ай бұрын
why total ranking is not calculated when you change filter
@SSM_33 Жыл бұрын
Damn bro
@Dimples-hc3te6 ай бұрын
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
@themightyvk10 ай бұрын
Thanks
@a5r6abdulrehman11 ай бұрын
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
@a5r6abdulrehman11 ай бұрын
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
Пікірлер: 53
The best opportunity for TOPN calculation, Thanks !
This is just amazing, thanks for posting such informative video 😊
What a great example ! Thank you for that !
Excellent thank you very much. This solution may be able assist with another problem I have have.
Awesome example, thanks!
Thanks for the great video! How would you advise filtering out items with a "zero" value in specific fields in the rankings?
Amazing explanations and very clean codes. Please make more videos on PBI relationships as well
Interesting. Thanks
Superb dude You're becoming my superhero of BI. You're making content very easy and simple. Thankyou Buddy 🎉
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?
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)
Great tutorial 👍
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?
Hi ,Thanks for the video & Could you pls make a video on COUNT N number of products achieved their target consecutive N months
Thanks
Very important and helpful video
Thnak you
Great 👍
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?
well done
Hello sir, would you considering making videos about integrating Machine Learning algorithms in PowerBI ? I have been watching you for a long while
Awesime. Can you actually show the top and bottom in the same visual?
Do you have any video for dynamically dimension, measurement and filter top/bottom measurement in one visualisation
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
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
8 ай бұрын
Hi do you found any solution?
Can I use switch() instead of if in return statement
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
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
Can you explain with switch function for more than two conditions
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.
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
Nice Vid, but why there is not total for the Bottom-Values?
Hello! How should it be when you want to get top 10 per week?
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
Ай бұрын
how to use it please ? i have this problem :(
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
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
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?
what if there is another filter --> date in the visual?
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
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
Why are the totals in Top Category Same and why are the total in Bottom Category not showing? Please help me
why total ranking is not calculated when you change filter
Damn bro
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
Thanks
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
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