Awesome video......I've gained so much from your videos and always look forward to your next challenge or tutorial. Thank you for all the valuable content. I have a question: I’m having trouble hiding the second column, 'Prod Name,' and every time I try, the height of the other columns keeps increasing. I’d really appreciate your help with this. God bless you!
Agin one of 👍👍TOP PRESENTATION 👍👍, we have two parts A+ and others, what if I want to create more groups with some condions, group A should have top 80% of sales, group B have at top of 50% and C top 30% and the others. Or some another percentage A=90%, B= 70%, C=40%, D=10%,and other, It would be nice as one additional video. TOP
I want to practice what you showed inn the video. But i do not have such data. Can you please give me the data also? Amazing video, beautifully taught by each part. Thank you!!!
was a wonderful video and it came in the right time I was thinking on the pareto visual. Howver I have an issue - RT Split = SWITCH( true(), value(SELECTEDVALUE('Split category table'[Value])="A+" & [Running contribution]
I have faced a problem. i have sales qty column in multiple table. sum all tables sales qty colum as well as sales target qty. and made another measure sales qty / sales target qty. all tables has division product wise 4 years sales data. now i want to count how much product sales ach% is greater than 100% for division? can you help me?
📌Learn DAX & Data Modelling - goodly.co.in/learn-dax-powerbi/
⬇Download the Power BI file - goodly.co.in/pareto-analysis-in-power-bi
This is amazing - so much content in half an hour. Thank you!
Excellent 🎉... thanks for sharing
Thanks for sharing this video with us. It was really easy to follow along and have helpful as always.
It's perfect. I have learned a lot about your knowledge as well as your logical reasoning step by step. Thank you very much.
Absolutely wonderful pure golden tutorial. Cool formulas, amazing examples and outstanding presentation 🎉❤
ما شاء الله عليك استاذنا الفاضل ❤
Very insightful & useful - thank you Chandeep!
great video ,my question is must i create a calculate group . can i just create a measure instead of a calculated group
excellent.....Thanks for teaching👍👍👍
Thanks for the wonderful tutorial. I have learned a lot.
Thanks for sharing !!! l learned a lot from your video.
Will have to watch this first thing in the morning 😂😅😊🙏🏻🙏🏻
So amazing, thanks Chandeep!!!
Very insightful visual. I am gonna add this to my next project fs.
I need the color value used in the final chart 😊
Again a great education
Truly amazing vid, really!
can we apply this in matrix as well?
Awesome video......I've gained so much from your videos and always look forward to your next challenge or tutorial. Thank you for all the valuable content. I have a question: I’m having trouble hiding the second column, 'Prod Name,' and every time I try, the height of the other columns keeps increasing. I’d really appreciate your help with this. God bless you!
Hii do you provide the course in emi options?
Unfortunately we dont have that option now
First like and comment is mine.😁
So elegant
Thanks
Nice work. I don't get the cross joined table though. Seems to work just fine with a two row table of the two categories and no relationship.
Agin one of 👍👍TOP PRESENTATION 👍👍, we have two parts A+ and others, what if I want to create more groups with some condions, group A should have top 80% of sales, group B have at top of 50% and C top 30% and the others. Or some another percentage A=90%, B= 70%, C=40%, D=10%,and other, It would be nice as one additional video. TOP
I want to practice what you showed inn the video. But i do not have such data. Can you please give me the data also? Amazing video, beautifully taught by each part. Thank you!!!
Hi sir do we have any EMI options for your course?
sorry not as of yet
was a wonderful video and it came in the right time I was thinking on the pareto visual. Howver I have an issue - RT Split = SWITCH(
true(),
value(SELECTEDVALUE('Split category table'[Value])="A+" & [Running contribution]
Use && instead of &
Anybody knows what is the app he is using to draw/annotate in his screen?
how can I make one of this and for example I have three table and I want whatever filter or percentage I choose the result changes in all 3?
Thnx 4 ur effort, please build up your file with us step by step ..i belive that u need to accelerate your video but build with us
Awesome!!
why I don't see the calculated groups feature in my PBI?
update it
@@GoodlyChandeepeven I don't see the calculation group native to my power bi inspite of updating it to latest October 2024 version
Great!
When I replace the product name with split category [prod name], the total sales became total amount across all the products. Where did I go wrong?
I have faced a problem. i have sales qty column in multiple table. sum all tables sales qty colum as well as sales target qty. and made another measure sales qty / sales target qty. all tables has division product wise 4 years sales data. now i want to count how much product sales ach% is greater than 100% for division? can you help me?
this is a lot of work and overhead for a simple view that can be done using SQL
impressive
IT IS GIVING ME ISSUE OF RESOURCES EXCEEDES EVEN THOUGH IF I filter?
Same here
Very very insightful🫡
Sundar IS FROM iit Kanpur
its Not working
Prod Name =
IF([Total Sales] && ISINSCOPE('Splite Category'[Prod Name]),SELECTEDVALUE('Splite Category'[Prod Name]),
VAR Tble = FILTER(ADDCOLUMNS(SUMMARIZE('Splite Category','Splite Category'[Prod Name],'Splite Category'[Value]),"Test",
VAR RT =CALCULATE(DIVIDE([Total Sales],CALCULATE([Total Sales],ALL('Splite Category'[Prod Name]))),
WINDOW(1,ABS,0,REL,ALL('Splite Category'[Prod Name]),ORDERBY([Total Sales],DESC)))
VAR TH =[Set Threshold]
RETURN
RT