Create an Insightful and Stunning Pareto Table in Power BI 🤯

[@GoodlyChandeep]

📌Learn DAX & Data Modelling - goodly.co.in/learn-dax-powerbi/ ⬇Download the Power BI file - goodly.co.in/pareto-analysis-in-power-bi

[@petercompton538]

This is amazing - so much content in half an hour. Thank you!

[@tranmanh26]

It's perfect. I have learned a lot about your knowledge as well as your logical reasoning step by step. Thank you very much.

[@emilmubarakshin49]

Absolutely wonderful pure golden tutorial. Cool formulas, amazing examples and outstanding presentation 🎉❤

[@dribeiro9564]

Thanks for sharing this video with us. It was really easy to follow along and have helpful as always.

[@mohamedabdoarmada7985]

ما شاء الله عليك استاذنا الفاضل ❤

[@vasudeva2957]

Thanks for the wonderful tutorial. I have learned a lot.

[@chrism9037]

So amazing, thanks Chandeep!!!

[@JohnHenry2009]

Very insightful & useful - thank you Chandeep!

[@niluthpalchowdhury]

Very insightful visual. I am gonna add this to my next project fs.

[@arbazahmad7177]

Excellent 🎉... thanks for sharing

[@oricchannel2811]

Thanks for sharing !!! l learned a lot from your video.

[@m.w.6099]

Truly amazing vid, really!

[@gusmoraes]

very good, thanks again, Chandeep

[@vacilando86]

Again a great education

[@julie_chen]

Will have to watch this first thing in the morning 😂😅😊🙏🏻🙏🏻

[@ashokkumarbhishma]

excellent.....Thanks for teaching👍👍👍

[@JenMayB]

I need the color value used in the final chart 😊

[@NirRobinson]

So elegant Thanks

[@mahadevshah3099]

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!

[@eniolaadekoya5623]

great video ,my question is must i create a calculate group . can i just create a measure instead of a calculated group

[@zorankrekic3006]

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

[@Rice0987]

First like and comment is mine.😁

[@ShubhsNagar]

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!!!

[@hamza_Techy]

Great!

[@abhishekplaywithdata]

Awesome!!

[@sameerulhaq4066]

can we apply this in matrix as well?

[@eslamfahmy87]

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

[@MrAtr1sk]

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.

[@mogarrett3045]

impressive

[@Sreerams26]

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]

[@mahadevshah3099]

Use && instead of &

[@tobiisagoodboy7935]

Anybody knows what is the app he is using to draw/annotate in his screen?

[@sameerulhaq4066]

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?

[@MohamedMontaser91]

this is a lot of work and overhead for a simple view that can be done using SQL

[@llo.welc_me]

Hii do you provide the course in emi options?

[@GoodlyChandeep]

Unfortunately we dont have that option now

[@gundappabukka2758]

Hi sir do we have any EMI options for your course?

[@GoodlyChandeep]

sorry not as of yet

[@the_technician]

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?

[@omarfaruk6661]

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?

[@jfelipevb]

why I don't see the calculated groups feature in my PBI?

[@GoodlyChandeep]

update it

[@rajeevmenon1975]

​@@GoodlyChandeepeven I don't see the calculation group native to my power bi inspite of updating it to latest October 2024 version

[@sameerulhaq4066]

IT IS GIVING ME ISSUE OF RESOURCES EXCEEDES EVEN THOUGH IF I filter?

[@manojmenezes8996]

Same here

[@shravanmj36]

Very very insightful🫡

[@chandrasekharmvv5477]

Sundar IS FROM iit Kanpur

[@amarycycycy4560]

its Not working

[@labzaper]

[@amarycycycy4560]

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