- 36
- 945 160
Power BI Park
Poland
Приєднався 28 лис 2011
Microsoft MVP, Power Bi Consultant in Poland 😊
If you want to connect, you can add me on Linkedin: www.linkedin.com/in/injae-park/
If you want my files, you can get them by supporting the channel: www.patreon.com/powerbipark/
If you want to connect, you can add me on Linkedin: www.linkedin.com/in/injae-park/
If you want my files, you can get them by supporting the channel: www.patreon.com/powerbipark/
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
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
Transform your POWER BI in 20 MIN with Themes and Backgrounds
Переглядів 78 тис.Рік тому
Transform your POWER BI in 20 MIN with Themes and Backgrounds
Can i get the python code in some file form , This is dropping errors..
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?
please help
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
Thank you so much! Amazing work
Amazing!! Thank you!!
Thanks so much for the valuable presentations!
Awesome work! Thanks for taking uns deep down into the rabbit hole and explainig your solutions in such a detailed manner! 👍
Great, I hope you learned something new from this :)
Awesome.
Glad you liked it! Hopefully it saves you some hours sometime
Sir can i image url based on the order id's of amazon, is there any possible things
How did you get the paretovalue, the slicer you move around, precentage.
It's the numeric range parameter, paretovalue = selectedvalue(parameter)
hey its really awesome man. A small request from me is to create a video on dax measures😅
That's a big request xD can you be more specific?
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🙏
Doesn't he have the code in his post? :)
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
A good way is to use window functions to resolve it :)
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.
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!
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!
Awesome, thanks for the feedback! Its something different I tried out, and I'm glad it resonated
Excelente muchas gracias me ha sido de mucha utilidad.
Glad you found it useful! :)
Just awesome
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.
Excellent! Following you on LinkedIn and was waiting for this video :)
Hope you enjoy it!
Thank you. I'm definitely going to try this.
Nice!
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.
Thanks! Do you mean that you need one cell to have multiple lines?
@@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)
Is that SQL you use?
only DAX in this video
@@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?
This is mock data, but you could for sure connect d365 data (I'm assuming dynamics) to power bi to do this
@@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?
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.
It is really helpful. Thank you and keep it up.
Glad it was helpful!
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
ah yes, but Pareto with negative doesn't always work - waterfall might be better :)
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😇
Thanks James :)
Thanks for showing things my company can actually use!
Glad it's helpful!
Could you also please share the dataset?
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:)
@@PowerBIPark Oh, totally makes sense. Thank you!
Very good implementation.
Many thanks
excellent demonstration as always. Your impact on Social Media is out of this world. Thank you very much
I appreciate that! If I don't see you on linkedin after a video I'll start to worry xD
@@PowerBIPark 😊 This is why i keep checking your posts daily. Thank u
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.
Thanks! This is a tiny dataset to show the visuals so it's not really relevant here, but I appreciate the comment
You deserve 100k followers! What you taught today was really 👌
Awesome. Appreciate you saying so :)
Legend! I am already following you on LinkedIn! thank you so much for your video!
Nice one. Hopefully this and the other videos help you out :)
Thank you!... you are very kind showing the "magic" on this sort of nice dashboard. I really appreciate it!
Happy to see you find value in it. Hopefully it'll be useful to you :)
Bro this is fire. Thank you! Keep making the content!
Thanks, appreciate it :)
@@PowerBIParknice
excellent.....love Pareto 80/20 rule, used it before
for sure! it's a shame it's not out of the box in power bi, but this will do the trick :)
Excellent...🎉 thanks for sharing
Hope its useful to you :)
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!
Where can I get the python code to get urls in the dataset?
Awsome, I didn't know for Bravo that can be used for external tools. Thanks for sharing with us 😊
while doing the spotify test app step what URL to be put in the required url box?
In the slicers using the released_year eliminates the possibility of having a year with no songs released
I subscribed
Great Video. If possible can you please record the video while you design the visualizations as well
why is my excel formated so weird when i open it? All the data is in one cell on each row
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. 👋😊
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 ,
@13:59 how did you auto select all fields to update at once?
It's ctr shift l. Here's a quick video explaining ua-cam.com/video/e7yxCQEbeYs/v-deo.html
Thanks for the Great Video. A better alternative to some third party visuals.
Glad you liked it!
Thank a lot for that tutorial it's a gold! Could you show also how to change chip icon for a custom one?
when i use the svg image measure it's barely visible i tried to increase several times and no change :(
Sorry about that. Svgs aren't really my forte, even i have to use chat gpt to fix it :(