⬇Download the file used in the video - goodly.co.in/dynamic-and-fixed-rankings-power-bi 🔗Recommended Videos: What is Filter Context? - th-cam.com/video/P9Q3I9QGjGY/w-d-xo.htmlsi=7x2Y0Jv8IsZDq4sN Context Transition in Power BI and Tricky Examples - th-cam.com/video/pTI2ASgecGA/w-d-xo.htmlsi=mtOQuxZJskZgweco Row Context and Context Transition - th-cam.com/video/NkYwwb7I3BY/w-d-xo.htmlsi=_e1R6bbBCE34Ws5a 💡Looking to Master Power BI? Check out my Comprehensive Course on DAX & Data Modeling! - goodly.co.in/learn-dax-powerbi/
I just found this video, you make it sound so easy. Question: how would apply ranking to a hierarchy? Example: I have an Accounts hierarchy with 5 levels and sales for each account. I would like to show the "n" top accounts; if "n" can be dynamically chosen then even better :)
sorry if this is a dumb question, but i'm trying to understand what specifically makes the 2nd solution "dynamic". Is it using a row context function? and how does it being combined with all(or all selected/except for that matter) help with the query being dynamic. (i know my comment comes across as a bit all over the place, but would appreciate any pointers, thanks!)
It is dynamic because the measure is being recalculated if you filtered any other column meanwhile the ranking coming from power query is static and is not going to be recalculated is you filter the underlying data
Incredible, much thanks to you brother. It would be great if you please share a video about deleting all column except the selected column from the column legend name in Power query. - Elias
Excellent explanation.. I have one question i am working on statistic control chart dashboard ,where there are various rules violation. Suppose for example Rule 1 says if consecutive points are below zero sigma then it is violating rule 1. I have successfully built all the rules and they are working fine. But the problem is whenever there is violation of rule 1, then at 8th point it is showing violation which is fine but i want to highlight 1 to 7 points along with 8th point so that it brings good user experience. To achieve that i have used dax measure but problem is measures are iterating row and i want result at column level. I also tried creating calculated column but it won't work. Is there any solution for it ?..
i need that for top 5 product based on sale it give product name and sale and for rest of products give a name rest and sum for there sale combined in table visual
@@rangasanthosh4956 Guys, I am a beginner in Power BI and still learning. I have a doubt about a DAX code. Could you please help me sort it out? I have a slicer connected to a table and the values are 'Group1', 'Group2', and 'Group3.' If the slicer's selection value is 'Group1', the day column should be filtered by Days >=0 and Days =0 and Days
@@rangasanthosh4956 How we can filter a table with multiple columns values ( for example I have a table contains products name, expiry date and status showing expire within 30days, 60 days, 90 days and 120 days. I have shown in my slicer values as 30 days, 60days, 90 days and 120 days. If I select the value as 30 then table will show all the products expire within 0 to 30 days and if if i select 60 days then I need see all the products from 0 to 60 days. How i can do this
⬇Download the file used in the video - goodly.co.in/dynamic-and-fixed-rankings-power-bi
🔗Recommended Videos:
What is Filter Context? - th-cam.com/video/P9Q3I9QGjGY/w-d-xo.htmlsi=7x2Y0Jv8IsZDq4sN
Context Transition in Power BI and Tricky Examples - th-cam.com/video/pTI2ASgecGA/w-d-xo.htmlsi=mtOQuxZJskZgweco
Row Context and Context Transition - th-cam.com/video/NkYwwb7I3BY/w-d-xo.htmlsi=_e1R6bbBCE34Ws5a
💡Looking to Master Power BI? Check out my Comprehensive Course on DAX & Data Modeling! - goodly.co.in/learn-dax-powerbi/
Hi Chandeep, pls create a video on calculating TAT which excludes regional holidays in power query. Thanks a lottt, your videos are very awesome
I spent 3 days and watched so many videos and went crazy trying to figure this out. THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!!
Love your unwavering dedication to share knowledge.
The best in this field, without a doubt. Excellent explanations again and again. Thanks Chandeep!
Why this guy's all videos are awesome, I am really in jealous, :)))
😂 🙌
I just found this video, you make it sound so easy. Question: how would apply ranking to a hierarchy? Example: I have an Accounts hierarchy with 5 levels and sales for each account. I would like to show the "n" top accounts; if "n" can be dynamically chosen then even better :)
Hi Chandeep, Thank you for sharing this tutorial. Very clear as always. see you next time. :)
Brilliant as always, thanks Chandeep!
Thanks again!
Nice video as usual Chandeep !!! .Instead of rankx i prefer to use rank function now.
Brilliant... Thank you Chandeep
sorry if this is a dumb question, but i'm trying to understand what specifically makes the 2nd solution "dynamic". Is it using a row context function? and how does it being combined with all(or all selected/except for that matter) help with the query being dynamic. (i know my comment comes across as a bit all over the place, but would appreciate any pointers, thanks!)
It is dynamic because the measure is being recalculated if you filtered any other column meanwhile the ranking coming from power query is static and is not going to be recalculated is you filter the underlying data
Explaining other ranking types also could have made in the video.
Incredible 🎉.. thanks for sharing
Amazing. So intelligent
Incredible, much thanks to you brother.
It would be great if you please share a video about deleting all column except the selected column from the column legend name in Power query.
- Elias
Excellent explanation..
I have one question i am working on statistic control chart dashboard ,where there are various rules violation.
Suppose for example Rule 1 says if consecutive points are below zero sigma then it is violating rule 1.
I have successfully built all the rules and they are working fine. But the problem is whenever there is violation of rule 1, then at 8th point it is showing violation which is fine but i want to highlight 1 to 7 points along with 8th point so that it brings good user experience.
To achieve that i have used dax measure but problem is measures are iterating row and i want result at column level. I also tried creating calculated column but it won't work. Is there any solution for it ?..
In dax how include rank by year?
Hi Chandeep, pls create a video on how to calculate TAT which excludes regional holidays in power query and DAX
Please send me some sample data and expected output. goodly.wordpress@gmail.com
@@GoodlyChandeep I have sent you sample file. Thank you!!
i need that for top 5 product based on sale it give product name and sale
and for rest of products give a name rest and sum for there sale combined
in table visual
is it not better to use AllSelected instead of All?
then you will have ranks updated from 1.
Yes if you are going to apply filter on products
Can you clear me one of my doubts? I am seeking your help
yeap
@@rangasanthosh4956 Guys, I am a beginner in Power BI and still learning. I have a doubt about a DAX code. Could you please help me sort it out? I have a slicer connected to a table and the values are 'Group1', 'Group2', and 'Group3.' If the slicer's selection value is 'Group1', the day column should be filtered by Days >=0 and Days =0 and Days
@@rangasanthosh4956 How we can filter a table with multiple columns values ( for example I have a table contains products name, expiry date and status showing expire within 30days, 60 days, 90 days and 120 days. I have shown in my slicer values as 30 days, 60days, 90 days and 120 days. If I select the value as 30 then table will show all the products expire within 0 to 30 days and if if i select 60 days then I need see all the products from 0 to 60 days. How i can do this
👏