Create an Insightful and Stunning Pareto Table in Power BI 🤯

Поділитися
Вставка
  • Опубліковано 24 гру 2024

КОМЕНТАРІ • 51

  • @GoodlyChandeep
    @GoodlyChandeep  5 місяців тому +3

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

  • @petercompton538
    @petercompton538 3 місяці тому +1

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

  • @dribeiro9564
    @dribeiro9564 2 місяці тому

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

  • @arbazahmad7177
    @arbazahmad7177 Місяць тому

    Excellent 🎉... thanks for sharing

  • @eniolaadekoya5623
    @eniolaadekoya5623 Місяць тому

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

  • @tranmanh26
    @tranmanh26 5 місяців тому

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

  • @mohamedabdoarmada7985
    @mohamedabdoarmada7985 4 місяці тому

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

  • @vasudeva2957
    @vasudeva2957 5 місяців тому

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

  • @JenMayB
    @JenMayB 5 днів тому

    I need the color value used in the final chart 😊

  • @JohnHenry2009
    @JohnHenry2009 5 місяців тому

    Very insightful & useful - thank you Chandeep!

  • @emilmubarakshin49
    @emilmubarakshin49 5 місяців тому +1

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

  • @oricchannel2811
    @oricchannel2811 5 місяців тому

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

  • @chrism9037
    @chrism9037 5 місяців тому

    So amazing, thanks Chandeep!!!

  • @mahadevshah3099
    @mahadevshah3099 4 місяці тому

    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!

  • @niluthpalchowdhury
    @niluthpalchowdhury 5 місяців тому

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

  • @m.w.6099
    @m.w.6099 5 місяців тому

    Truly amazing vid, really!

  • @vacilando86
    @vacilando86 5 місяців тому

    Again a great education

  • @llo.welc_me
    @llo.welc_me 2 місяці тому

    Hii do you provide the course in emi options?

    • @GoodlyChandeep
      @GoodlyChandeep  2 місяці тому

      Unfortunately we dont have that option now

  • @sameerulhaq4066
    @sameerulhaq4066 4 місяці тому

    can we apply this in matrix as well?

  • @MrAtr1sk
    @MrAtr1sk 5 місяців тому

    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.

  • @NirRobinson
    @NirRobinson 5 місяців тому

    So elegant
    Thanks

  • @ashokkumarbhishma
    @ashokkumarbhishma 5 місяців тому

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

  • @ShubhsNagar
    @ShubhsNagar 4 місяці тому

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

  • @gundappabukka2758
    @gundappabukka2758 5 місяців тому

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

  • @tobiisagoodboy7935
    @tobiisagoodboy7935 5 місяців тому

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

  • @Sreerams26
    @Sreerams26 5 місяців тому

    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]

  • @sameerulhaq4066
    @sameerulhaq4066 4 місяці тому

    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?

  • @abhishekplaywithdata
    @abhishekplaywithdata 5 місяців тому

    Awesome!!

  • @hamza_Techy
    @hamza_Techy 4 місяці тому

    Great!

  • @julie_chen
    @julie_chen 5 місяців тому

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

  • @eslamfahmy87
    @eslamfahmy87 5 місяців тому

    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

  • @jfelipevb
    @jfelipevb 5 місяців тому

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

    • @GoodlyChandeep
      @GoodlyChandeep  5 місяців тому +1

      update it

    • @rajeevmenon1975
      @rajeevmenon1975 Місяць тому

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

  • @the_technician
    @the_technician 5 місяців тому

    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?

  • @mogarrett3045
    @mogarrett3045 5 місяців тому

    impressive

  • @omarfaruk6661
    @omarfaruk6661 5 місяців тому

    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?

  • @Rice0987
    @Rice0987 5 місяців тому

    First like and comment is mine.😁

  • @zorankrekic3006
    @zorankrekic3006 5 місяців тому +1

    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

  • @sameerulhaq4066
    @sameerulhaq4066 4 місяці тому

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

  • @MohamedMontaser91
    @MohamedMontaser91 3 місяці тому

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

  • @shravanmj36
    @shravanmj36 5 місяців тому

    Very very insightful🫡

  • @chandrasekharmvv5477
    @chandrasekharmvv5477 5 місяців тому

    Sundar IS FROM iit Kanpur

  • @amarycycycy4560
    @amarycycycy4560 25 днів тому

    its Not working

  • @labzaper
    @labzaper 4 місяці тому

  • @amarycycycy4560
    @amarycycycy4560 25 днів тому

    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