Power BI Park
Power BI Park
  • 36
  • 945 160
Dynamic Pareto Analysis in Power BI - Native Visuals
Guided Pareto Tutorial with PBIX file
Did you like this video? let me know, I might make more like this if there's a good response from the community
::::::::::: Links :::::::::::::::
🔥 PBIX here➡️: github.com/PowerBIPark/PowerBITutorials
🔥 Gustaw's Original Post: www.linkedin.com/feed/update/urn:li:activity:7207444783869345793/
::::::::::::::::::::::::::::::::::
Come find me on Linkedin: www.linkedin.com/in/injae-park/
Thanks for taking the time to watch this video.
#PowerBI #DataAnalytics #BusinessIntelligence #powerquery
Переглядів: 7 172

Відео

Cashflow / P&L Statement in Power BI - (May 2024 Update)
Переглядів 10 тис.Місяць тому
Learn how to make this with my guided tutorial. ::::::::::: Links ::::::::::::::: 🔥 PBIX here: github.com/PowerBIPark/PowerBITutorials 🔥 Power BI May 2024 update: www.microsoft.com/en-us/download/details.aspx?id=58494 🔥 Matrix Layout updates: www.linkedin.com/pulse/new-power-bi-matrix-layouts-pbicorevisuals-cr1if/?trackingId=Af5OG1TpMZrtV9ufiMJ1pg 🔥 NATIVE Power BI Table - Advanced tutorial: ua...
Power BI StreetFighter Report Tutorial (For Beginners)
Переглядів 4,7 тис.2 місяці тому
Learn how to use ImgURLs and SVGs to make this report. This was a fun little report - it doesn't hold too much business value, but I hope you learn from this anyway. 🔥The Data: github.com/PowerBIPark/StreetFighterReport 🔥Luis's Channel: ua-cam.com/video/SeFzOhhmsvM/v-deo.htmlsi=YSDEU4ylmOuhTJZ5 Come find me on Linkedin: www.linkedin.com/in/injae-park/ Thanks for taking the time to watch this vi...
How to Bulk Edit Measures in Power BI - With Excel Template
Переглядів 2,4 тис.2 місяці тому
This is a free Template to help you deal with a large number of Measures 0:00 - Intro 1:43 - Extract Measures 4:57 - Using the Template 10:16 - Formatting Measures 🔥The Template: github.com/PowerBIPark/Advanced-Script-Generator-For-Measures 🔥Tabular editor : docs.tabulareditor.com/ 🔥Advanced Scripting: docs.tabulareditor.com/te2/Useful-script-snippets.html 🔥Bravo: bravo.bi/ 🔥Vertipaq analyzer: ...
How You Can Version Control PowerQuery (Run Code From GitHub)
Переглядів 4,2 тис.3 місяці тому
💠Get all the code: github.com/PowerBIPark/PowerBI_MQueryTest ⏰Timestamps: 0:00 - Intro 00:30 - From a Local File 02:37 - From the Web 05:56 - Dealing with Shared keyword 11:44 - Adding Parameters 15:10 - Creating a PQ Library 📎Links: → gorilla.bi/power-query/date-table/ → www.reddit.com/r/PowerBI/comments/ckdk9v/powerquery_call_custom_functions_file_from_github/ → github.com/PowerBIPark/PowerBI...
[IBCS] Advanced Power BI Tutorial - Native Bar Chart (With PBIX)
Переглядів 8 тис.4 місяці тому
::::::::::: Links ::::::::::::::: 🔥PBIX here: workout-wednesday.com/pbi-2024-w11/ 🔥 IBCS style Matrix Tutorial: ua-cam.com/video/Oe6hq4I32tg/v-deo.htmlsi=R37Rk3BzFMKLDMcb 🔥 IBCS Template: www.ibcs.com/resource/multi-tier-column-chart/ 🔥 PBI Core Visual Update: www.linkedin.com/pulse/additional-enhancements-columns-bars-ribbons-pbicorevisuals-u2lie?trackingId=KdCy7OKoTl%2BaJUdHZdK3%2BA%3D%3D/?tr...
[IBCS] Advanced Power BI Tutorial - Native Column Chart
Переглядів 10 тис.4 місяці тому
Get a 3 for 1 deal on Charts in Power BI ::::::::::: Links ::::::::::::::: 🔥 IBCS style Matrix Tutorial: ua-cam.com/video/Oe6hq4I32tg/v-deo.htmlsi=R37Rk3BzFMKLDMcb 🔥 IBCS Template: www.ibcs.com/resource/multi-tier-column-chart/ 🔥 PBI Core Visual Update: www.linkedin.com/pulse/additional-enhancements-columns-bars-ribbons-pbicorevisuals-u2lie?trackingId=KdCy7OKoTl%2BaJUdHZdK3%2BA%3D%3D/?trackingI...
[IBCS] New Column chart in Power BI - Feb 2024 Update
Переглядів 20 тис.4 місяці тому
This is a tutorial on clustered bar charts in Power BI 🔥 IBCS Template: www.ibcs.com/resource/multi-tier-bar-charts/ 🔥 PBI Core Visual Update: www.linkedin.com/pulse/additional-enhancements-columns-bars-ribbons-pbicorevisuals-u2lie?trackingId=KdCy7OKoTl%2BaJUdHZdK3%2BA%3D%3D/?trackingId=KdCy7OKoTl+aJUdHZdK3+A 🔥 IBCS style Matrix Tutorial: ua-cam.com/video/Oe6hq4I32tg/v-deo.htmlsi=R37Rk3BzFMKLDM...
NATIVE Power BI Table - Advanced Tutorial
Переглядів 18 тис.4 місяці тому
Make this with a native PBI Table! Andrzej's Github🔥github.com/avatorl/IBCS-for-Power-BI Andrzej's IBCS video🔥ua-cam.com/video/RAiMq2MWDHM/v-deo.html&ab_channel=DataVisualizationinPowerBIandBeyond Davide's Github🔥github.com/PBI-David/SVG Brian Julius' post: TOCSV🔥www.linkedin.com/posts/brianjuliusdc_tocsv-best-practices-activity-7157252558837678080-OR9N? Kerry Kolosko's SVG Templates🔥kerrykolos...
New Button Slicer Tutorial - Power BI (Nov 2023 Update)
Переглядів 18 тис.7 місяців тому
Step-by-step: Make this Report with Native Power BI Visuals! This is how to use the New Slicer Visual 🔥Original Design: www.linkedin.com/posts/matthewspuffard_websitedeveloper-powerbi-nike-activity-6970636591924944896-m7Fp? 🔥baseone.uk/ 🔥Dataset: data.world/data-hut/product-data-from-nike 🔥Download the latest Desktop version: www.microsoft.com/en-us/download/details.aspx?id=58494 00:00 - Intro ...
Advanced Power BI Project • End-to-End • ChatGPT • Custom Visuals
Переглядів 268 тис.9 місяців тому
Advanced Power BI Project • End-to-End • ChatGPT • Custom Visuals
5 Shortcuts to write DAX faster - Power BI
Переглядів 19 тис.9 місяців тому
5 Shortcuts to write DAX faster - Power BI
Code Interpreter for Data Analysis - ChatGPT (July 2023 update)
Переглядів 23 тис.10 місяців тому
Code Interpreter for Data Analysis - ChatGPT (July 2023 update)
New Card Visual Tutorial - Power BI (June 2023 Update)
Переглядів 128 тис.Рік тому
New Card Visual Tutorial - Power BI (June 2023 Update)
Copilot in Power BI - Quick Measures (May 2023 Update)
Переглядів 17 тис.Рік тому
Copilot in Power BI - Quick Measures (May 2023 Update)
Dynamic Format Strings 💠 Basic to Advanced: 5 Techniques
Переглядів 11 тис.Рік тому
Dynamic Format Strings 💠 Basic to Advanced: 5 Techniques
Master Scatterplots in Power BI: A Step-by-Step Tutorial
Переглядів 27 тис.Рік тому
Master Scatterplots in Power BI: A Step-by-Step Tutorial
LEVEL UP with Custom Visuals: Power BI🔹HTML🔹Calculation Groups🔹Deneb
Переглядів 8 тис.Рік тому
LEVEL UP with Custom Visuals: Power BI🔹HTML🔹Calculation Groups🔹Deneb
3 Step Power BI Design
Переглядів 6 тис.Рік тому
3 Step Power BI Design
Transform your POWER BI in 20 MIN with Themes and Backgrounds
Переглядів 78 тис.Рік тому
Transform your POWER BI in 20 MIN with Themes and Backgrounds
Make 1000+ DAX MEASURES in 10 MINS
Переглядів 31 тис.Рік тому
Make 1000 DAX MEASURES in 10 MINS

КОМЕНТАРІ

  • @nakul--
    @nakul-- 18 годин тому

    Can i get the python code in some file form , This is dropping errors..

  • @hirasiddiqui7265
    @hirasiddiqui7265 2 дні тому

    I'm applying for a jpg format image and when I apply background image , the jpg format shows white background, disturbing the whole box, what should I do?

  • @royarahmatian4541
    @royarahmatian4541 2 дні тому

    Hello, sorry, the value of ∆PY% is dumb for me. I count the values ​​by hand, but this cannot be calculated at all. Now the month of January will be 133, not 153. Similarly, the following months

  • @benfianso2623
    @benfianso2623 3 дні тому

    Thank you so much! Amazing work

  • @mariaclara8871
    @mariaclara8871 4 дні тому

    Amazing!! Thank you!!

  • @thomasd8888
    @thomasd8888 4 дні тому

    Thanks so much for the valuable presentations!

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

    Awesome work! Thanks for taking uns deep down into the rabbit hole and explainig your solutions in such a detailed manner! 👍

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

      Great, I hope you learned something new from this :)

  • @rapatel1642
    @rapatel1642 7 днів тому

    Awesome.

    • @PowerBIPark
      @PowerBIPark 7 днів тому

      Glad you liked it! Hopefully it saves you some hours sometime

  • @neelimaneelu2792
    @neelimaneelu2792 7 днів тому

    Sir can i image url based on the order id's of amazon, is there any possible things

  • @ZainDar-t5r
    @ZainDar-t5r 9 днів тому

    How did you get the paretovalue, the slicer you move around, precentage.

    • @PowerBIPark
      @PowerBIPark 9 днів тому

      It's the numeric range parameter, paretovalue = selectedvalue(parameter)

  • @ABINESHK-re7iu
    @ABINESHK-re7iu 9 днів тому

    hey its really awesome man. A small request from me is to create a video on dax measures😅

    • @PowerBIPark
      @PowerBIPark 9 днів тому

      That's a big request xD can you be more specific?

  • @lixiasong3459
    @lixiasong3459 10 днів тому

    thank you so much for the awesome YT, could you please make other YT about hiding items within one slicer if the same item is selected in another slice? mentioned by Gustaw on the Linkedin recently? please🙏

    • @PowerBIPark
      @PowerBIPark 9 днів тому

      Doesn't he have the code in his post? :)

  • @SumanKoirala-x6t
    @SumanKoirala-x6t 10 днів тому

    a small confusion as I was going through this, what do we do if we have multiple customers where the revenue generated is same? maybe like 3 customers with revenue of 1m USD each

    • @PowerBIPark
      @PowerBIPark 9 днів тому

      A good way is to use window functions to resolve it :)

  • @CHQAQC
    @CHQAQC 11 днів тому

    Thanks for a superb video. An issue I had in past using rank for pareto is when you have equal revenue for, in this example, customers. The ranking double count and the cumulative % is impacted. I remember I needed a work around to solve that issue.

    • @PowerBIPark
      @PowerBIPark 11 днів тому

      Oh for sure. Rank with dense or skip doesn't really resolve it, so if you have the same values you need a workaround. Nice callout!

  • @andresramirezortega6218
    @andresramirezortega6218 11 днів тому

    I love this! I was looking for a Pareto analysis like this! This example is so well explained and super appealing from my perspective! Super nice!

    • @PowerBIPark
      @PowerBIPark 11 днів тому

      Awesome, thanks for the feedback! Its something different I tried out, and I'm glad it resonated

  • @MauricioPPardo
    @MauricioPPardo 11 днів тому

    Excelente muchas gracias me ha sido de mucha utilidad.

    • @PowerBIPark
      @PowerBIPark 11 днів тому

      Glad you found it useful! :)

  • @writetoprithvi
    @writetoprithvi 12 днів тому

    Just awesome

  • @jaimerrojasrojas5924
    @jaimerrojasrojas5924 12 днів тому

    Great!!! The initial balance is a value already calculated in your DATA, please I need a guide to calculate the initial balance of a period with DAX.

  • @amaniezzat2942
    @amaniezzat2942 13 днів тому

    Excellent! Following you on LinkedIn and was waiting for this video :)

  • @tinaflemons263
    @tinaflemons263 13 днів тому

    Thank you. I'm definitely going to try this.

  • @Nikol_YouTube
    @Nikol_YouTube 14 днів тому

    Hi Injae, thank you for this and all your work! All i came to say is, that I needed more than one row to have a single line, and i created multiple calculated groups, one for each of my items. If anyone used a better way, I would love to know.

    • @PowerBIPark
      @PowerBIPark 14 днів тому

      Thanks! Do you mean that you need one cell to have multiple lines?

    • @Nikol_YouTube
      @Nikol_YouTube 9 днів тому

      @@PowerBIPark i have multiple rows, a total cash row for example and another 2 rows that do the same thing, they dont have subcategories. I tried to create one calculated group and put all the options there, to select them as items, but it didnt work. it would only fix the first option. I ended up using 3 calculated groups on the filter panel, one for each row i wanted to remove the extra lines from (to remove the repetitive lines in the subcategory part)

  • @ShoOnlineAcademy
    @ShoOnlineAcademy 15 днів тому

    Is that SQL you use?

    • @PowerBIPark
      @PowerBIPark 15 днів тому

      only DAX in this video

    • @ShoOnlineAcademy
      @ShoOnlineAcademy 15 днів тому

      @@PowerBIPark Thank you. What kind of ERP system did you pull the data from? if we are using Microsoft D365, can we build KPI dashboard in D365?

    • @PowerBIPark
      @PowerBIPark 15 днів тому

      This is mock data, but you could for sure connect d365 data (I'm assuming dynamics) to power bi to do this

    • @ShoOnlineAcademy
      @ShoOnlineAcademy 15 днів тому

      @@PowerBIPark yes Dynsmics. Both Power BI and Dynamics are Microsoft products. I was told thst tgey couldn't build tge dashboard in Dynamics. Ihow can we buikd dashboard inside dynamics?

    • @PowerBIPark
      @PowerBIPark 15 днів тому

      Maybe this will help community.dynamics.com/blogs/post/?postid=3d6f32cf-71e4-48f9-b1cf-193e7a4c5cd2#:~:text=To%20add%20Power%20BI%20visualizations,Allow%20Power%20BI%20visualization%20embedding.

  • @ali.jawwad
    @ali.jawwad 15 днів тому

    It is really helpful. Thank you and keep it up.

  • @ChocoHammer
    @ChocoHammer 15 днів тому

    When I was doing my first Pareto in Power BI, it surprised me how easy it was :D, but now I'm working on a Pareto graph on currency data with both positive and negative numbers :D. That's not easy anymore :D

    • @PowerBIPark
      @PowerBIPark 15 днів тому

      ah yes, but Pareto with negative doesn't always work - waterfall might be better :)

  • @jamesarthur2360
    @jamesarthur2360 15 днів тому

    I love this video, very detailed. The length of the video is worth it as Injae Park takes time to explain the nitty-gritty of the steps😇

  • @cathrerinezetadrones3169
    @cathrerinezetadrones3169 16 днів тому

    Thanks for showing things my company can actually use!

  • @mrbartuss1
    @mrbartuss1 16 днів тому

    Could you also please share the dataset?

    • @PowerBIPark
      @PowerBIPark 16 днів тому

      Hey Bartek, so you can just grab the data from the pbi file, just go to the table in the data view and right click on it and just copy the table. As you can see in the video, it's really just 2 columns of 19 rows:)

    • @mrbartuss1
      @mrbartuss1 15 днів тому

      @@PowerBIPark Oh, totally makes sense. Thank you!

  • @In_a_state
    @In_a_state 16 днів тому

    Very good implementation.

  • @abdelraoufyessoufou3190
    @abdelraoufyessoufou3190 16 днів тому

    excellent demonstration as always. Your impact on Social Media is out of this world. Thank you very much

    • @PowerBIPark
      @PowerBIPark 16 днів тому

      I appreciate that! If I don't see you on linkedin after a video I'll start to worry xD

    • @abdelraoufyessoufou3190
      @abdelraoufyessoufou3190 16 днів тому

      @@PowerBIPark 😊 This is why i keep checking your posts daily. Thank u

  • @andreyanpilov2593
    @andreyanpilov2593 16 днів тому

    Good video, thank you. I think you can optimize your model if you make addition transformation on PQ side. I would suggest to unpivot other columns than MonthNumber and Month.

    • @PowerBIPark
      @PowerBIPark 14 днів тому

      Thanks! This is a tiny dataset to show the visuals so it's not really relevant here, but I appreciate the comment

  • @luisfernandomacedo1451
    @luisfernandomacedo1451 16 днів тому

    You deserve 100k followers! What you taught today was really 👌

    • @PowerBIPark
      @PowerBIPark 16 днів тому

      Awesome. Appreciate you saying so :)

  • @clipe84
    @clipe84 16 днів тому

    Legend! I am already following you on LinkedIn! thank you so much for your video!

    • @PowerBIPark
      @PowerBIPark 16 днів тому

      Nice one. Hopefully this and the other videos help you out :)

  • @ricardocontreras
    @ricardocontreras 17 днів тому

    Thank you!... you are very kind showing the "magic" on this sort of nice dashboard. I really appreciate it!

    • @PowerBIPark
      @PowerBIPark 17 днів тому

      Happy to see you find value in it. Hopefully it'll be useful to you :)

  • @ThoNguyen-kq7ob
    @ThoNguyen-kq7ob 17 днів тому

    Bro this is fire. Thank you! Keep making the content!

  • @mogarrett3045
    @mogarrett3045 17 днів тому

    excellent.....love Pareto 80/20 rule, used it before

    • @PowerBIPark
      @PowerBIPark 17 днів тому

      for sure! it's a shame it's not out of the box in power bi, but this will do the trick :)

  • @arbazahmad7177
    @arbazahmad7177 17 днів тому

    Excellent...🎉 thanks for sharing

  • @ShirishaB-wk9zf
    @ShirishaB-wk9zf 18 днів тому

    Great video !! between i have a problem in the heatmap visual. I have the changed the settings from SVG to Canvas and using a Vega-lite. May i know where the second place is do we need to change the code. would be helpful to complete the report. Thanks!

  • @nirajmahajan2147
    @nirajmahajan2147 18 днів тому

    Where can I get the python code to get urls in the dataset?

  • @KatetinaSarkisian
    @KatetinaSarkisian 19 днів тому

    Awsome, I didn't know for Bravo that can be used for external tools. Thanks for sharing with us 😊

  • @_ARYANYUAN
    @_ARYANYUAN 19 днів тому

    while doing the spotify test app step what URL to be put in the required url box?

  • @anushkapanikulam2023
    @anushkapanikulam2023 21 день тому

    In the slicers using the released_year eliminates the possibility of having a year with no songs released

  • @khurrumsandhu
    @khurrumsandhu 22 дні тому

    I subscribed

  • @mithileshmenakuru2656
    @mithileshmenakuru2656 22 дні тому

    Great Video. If possible can you please record the video while you design the visualizations as well

  • @duudiduudu
    @duudiduudu 22 дні тому

    why is my excel formated so weird when i open it? All the data is in one cell on each row

  • @Belhakor
    @Belhakor 23 дні тому

    Great Video, As it's been a while since the video was released I doubt that my comment will have much impact but if it can be of use to anyone, By putting "Max value" in the second position of the Y Axis we can reduce the Space between categories to 25% for a better distinction between categories and deltas. 👋😊

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

    so eveyrthing is free , and you used the latest matrix visuals update ? i'll do it later thi sweek, thanks a lot, we need more tutorials like this :) other question, at 11min when you set the format and display units for each specific column, can't you do it for several column in the same time ,

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

    @13:59 how did you auto select all fields to update at once?

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

      It's ctr shift l. Here's a quick video explaining ua-cam.com/video/e7yxCQEbeYs/v-deo.html

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

    Thanks for the Great Video. A better alternative to some third party visuals.

  • @user-vx4qt1vu3q
    @user-vx4qt1vu3q Місяць тому

    Thank a lot for that tutorial it's a gold! Could you show also how to change chip icon for a custom one?

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

    when i use the svg image measure it's barely visible i tried to increase several times and no change :(

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

      Sorry about that. Svgs aren't really my forte, even i have to use chat gpt to fix it :(