- 5
- 42 034
Next Level Power BI Reports
United States
เข้าร่วมเมื่อ 4 ก.พ. 2023
I'm Gary, a Sr. Data Analyst / Power Bi Report Developer who specializes in UX/UI Design.
In 2023, I founded Next Level Reports with the mission to teach and inspire professionals to incorporate advanced and proven UX/UI strategies and techniques into their presentations and reports.
I'm passionate about helping others advance their careers and skills by transforming their data into result-driven stories that are compelling, impactful, beautiful, accessible, and user-centered focused.
Check out my Links below!
In 2023, I founded Next Level Reports with the mission to teach and inspire professionals to incorporate advanced and proven UX/UI strategies and techniques into their presentations and reports.
I'm passionate about helping others advance their careers and skills by transforming their data into result-driven stories that are compelling, impactful, beautiful, accessible, and user-centered focused.
Check out my Links below!
Master Dynamic MoM & YoY % Variance DAX Measures in Power BI
📊Dynamic MoM & YoY % Variance in Power BI - A Step-by-Step DAX Tutorial
🚀 In this tutorial, I’ll walk you through creating dynamic Month-over-Month (MoM) and Year-over-Year (YoY) DAX measures step by step. Learn how to show variances between two periods in a clear, actionable way-a key UX/UI component for impactful Power BI reports.
🎓What You’ll Learn in This Power BI UX/UI Tutorial:
📊 Dynamic MoM % Measure: Build and tweak a flexible MoM variance measure step by step.
📈 Dynamic YoY % Measure: Transform your MoM measure into a rolling 12-month YoY measure-or any other custom period-with ease.
📅 Master the EOMONTH Function: Learn how to create flexible, rolling date ranges with this essential DAX function, explained in detail with examples.
📝 Dynamic Text Labels: Visually show the time periods your MoM and YoY measures reference so stakeholders always understand the insights.
🌟Why Watch This Tutorial?
This video teaches you how to craft flexible, dynamic variance measures in DAX, elevating your Power BI reports with clear and actionable insights. Perfect for delivering stunning UX/UI-designed dashboards with context that stakeholders will love!
🤝If you found this video helpful, don’t forget to:
🔔 Like, Subscribe, and Turn on Notifications to stay updated!
💬 Comment with your feedback or ideas for future tutorials.
💌 Share this video with others who would love to level up their Power BI skills.
💡 Bonus!
Want to practice with the exact dataset featured in this tutorial? Enroll in my course, "14 Days to Mastering Power BI UX/UI Design." This program gives you the tools to create stunning, next-level Power BI reports. ✨ Enroll Now: 👉 courses.nextlevelreports.com/14-days-mastering-ux-ui-design-website-path 🚀
🔗Link to "Take your Power BI Cards to the Next Level - Full PBI UX/UI Tutorial "👉 th-cam.com/video/uuT6rpbugsY/w-d-xo.html
🔗Link to DAX MoM and YoY measures used in this tutorial👉drive.google.com/file/d/1WxZH4-qm5onm2lBF9qgMuAO5qa5BSfs9/view?usp=sharing
#PowerBI #DAXTutorial #DataVisualization #UXUIDesign #PowerBIDesign #PowerBIReports #NextLevelReports #VarianceMeasures
🚀 In this tutorial, I’ll walk you through creating dynamic Month-over-Month (MoM) and Year-over-Year (YoY) DAX measures step by step. Learn how to show variances between two periods in a clear, actionable way-a key UX/UI component for impactful Power BI reports.
🎓What You’ll Learn in This Power BI UX/UI Tutorial:
📊 Dynamic MoM % Measure: Build and tweak a flexible MoM variance measure step by step.
📈 Dynamic YoY % Measure: Transform your MoM measure into a rolling 12-month YoY measure-or any other custom period-with ease.
📅 Master the EOMONTH Function: Learn how to create flexible, rolling date ranges with this essential DAX function, explained in detail with examples.
📝 Dynamic Text Labels: Visually show the time periods your MoM and YoY measures reference so stakeholders always understand the insights.
🌟Why Watch This Tutorial?
This video teaches you how to craft flexible, dynamic variance measures in DAX, elevating your Power BI reports with clear and actionable insights. Perfect for delivering stunning UX/UI-designed dashboards with context that stakeholders will love!
🤝If you found this video helpful, don’t forget to:
🔔 Like, Subscribe, and Turn on Notifications to stay updated!
💬 Comment with your feedback or ideas for future tutorials.
💌 Share this video with others who would love to level up their Power BI skills.
💡 Bonus!
Want to practice with the exact dataset featured in this tutorial? Enroll in my course, "14 Days to Mastering Power BI UX/UI Design." This program gives you the tools to create stunning, next-level Power BI reports. ✨ Enroll Now: 👉 courses.nextlevelreports.com/14-days-mastering-ux-ui-design-website-path 🚀
🔗Link to "Take your Power BI Cards to the Next Level - Full PBI UX/UI Tutorial "👉 th-cam.com/video/uuT6rpbugsY/w-d-xo.html
🔗Link to DAX MoM and YoY measures used in this tutorial👉drive.google.com/file/d/1WxZH4-qm5onm2lBF9qgMuAO5qa5BSfs9/view?usp=sharing
#PowerBI #DAXTutorial #DataVisualization #UXUIDesign #PowerBIDesign #PowerBIReports #NextLevelReports #VarianceMeasures
มุมมอง: 2 769
วีดีโอ
Take your Power BI Cards to the Next Level - Full PBI UX/UI Tutorial
มุมมอง 10K14 วันที่ผ่านมา
🎨 Create Stunning, Next-Level UX/UI Custom Cards in Power BI! 🔥 Transform your Power BI reports with this FREE, in-depth tutorial! Learn how to design modern, intuitive Power BI Card groups that will elevate your data storytelling to new heights. Whether you're a beginner or a seasoned user, this guide is packed with everything you need to wow your audience. What You'll Learn in This Power BI U...
Take your Power BI Navigation Menus to the Next Level - Full PBI UX/UI Design Tutorial
มุมมอง 19K21 วันที่ผ่านมา
🚀 Are your Power BI navigation menus feeling a little... basic? Let’s fix that🌟 Familiar, user-friendly, intuitive navigation panes are essential for creating reports that stand out. While Power BI's built-in Page Navigator tool is a great start, what if you could take it further-turning your menus into visually stunning, website-like sub menus? In my latest advanced tutorial, you’ll learn: ✅ S...
Take your Power BI Tables to the Next Level - Full PBI UX/UI Design Tutorial
มุมมอง 7K2 หลายเดือนก่อน
Transform your Power BI Tables from Dull to Engaging! If you're a Power BI Report developer, you know how important tables are for certain audiences. But let’s face it-default table visuals can feel boring and dull. They don’t have to be though! 🎯 With a few design tweaks, you can turn those bland Power BI tables into sleek, app-like visuals that enhance the user experience. 📄 Download the FREE...
Build THIS Modern Power BI UI - Timelapse
มุมมอง 3.8Kปีที่แล้ว
Modern, UI/UX Designed Microsoft Power BI Report and Dashboard Build - Timelapse! Enjoy this timelapse of me creating a modern, UX/UI designed Power BI report from the ground up! (change video quality to HD) Course available on Udemy 👉 www.udemy.com/course/modern-powerbi-report-build/?referralCode=66C42A16EB72003EA559
WAOOO AMOIGO EXCELENTE GRACIAS
You're welcome 👍
You should show us those DAX MEASURE TO GIVE US IDEA OF TWHY IS IT INCLUDED IN THE REPORTS
Here you go th-cam.com/video/B0KRfybXvh0/w-d-xo.htmlsi=L2gAGGTbGMD1KB-8
Thanks sir Please make a complete tutorial on this project
Hello! If interested in building the exact report in the video, feel free to check out my full Power BI UX/UI course --> courses.nextlevelreports.com/order-form-14-days-to-mastering-power-bi-ux-ui-design-website-path
Sir kindly upload 😊 basic to advanced video in bi 😊 really helpful
I'm glad these videos have been helpful! Feel free to check my course if you're looking for a complete program on Power BI UX/UI Design! --> courses.nextlevelreports.com/order-form-14-days-to-mastering-power-bi-ux-ui-design-website-path
The indepth instructions you provided are phenomenal. I'm bookmarking this in my favorites.
Glad you found it helpful! 👍
Great Video! I’d glad you to mention cases with partial month comparison. For ex: Today we are at 12/9/24 so the comparison should be 12/1-12/8 vs. 11/1-11/8 (and not in compare to whole November).
@alono2323 yep!..we'd just have to tweak a little bit. One approach I would say could be to capture the % of days that have elapsed within the latest available month in the dataset, and then multiply % by the previous month sales. There's many ways to write DAX code for time periods, but the below I believe would work: Gross Sales MoM% (% Elapsed) = VAR _LatestVisiblePeriod = MAX( DIM_Date[Reporting Period] ) VAR _CurrentMonthStart = CALCULATE( MIN( DIM_Date[Date] ), DIM_Date[Reporting Period] = _LatestVisiblePeriod ) VAR _CurrentMonthLatestDate = CALCULATE( MAX( DIM_Date[Date] ), DIM_Date[Reporting Period] = _LatestVisiblePeriod ) VAR DaysElapsedCurrentMonth = DATEDIFF( _CurrentMonthStart,_CurrentMonthLatestDate,DAY ) VAR EndofMonthDateForCurrentMonth = EOMONTH(_CurrentMonthStart,0) VAR DaysinCurrentMonth = DATEDIFF( _CurrentMonthStart,EndofMonthDateForCurrentMonth,DAY ) VAR ElapsedPercentageCurrentMonth = DIVIDE(DaysElapsedCurrentMonth,DaysinCurrentMonth,0) VAR _PreviousMonthSales= CALCULATE( [Gross Sales], REMOVEFILTERS( DIM_Date ), DATESBETWEEN( DIM_Date[Date], EOMONTH( _CurrentMonthStart, -2 ) + 1, EOMONTH( _CurrentMonthStart, -1 ) ) ) * ElapsedPercentageCurrentMonth VAR _CurrentMonthSales = CALCULATE( [Gross Sales], REMOVEFILTERS( DIM_Date ), DATESBETWEEN( DIM_Date[Date], EOMONTH( _CurrentMonthStart, -1 ) + 1, EOMONTH( _CurrentMonthStart, 0 ) ) ) VAR _Result = IF( _PreviousMonthSales > 0, (_CurrentMonthSales - _PreviousMonthSales ) / _PreviousMonthSales, BLANK() ) RETURN _Result
Will u maybe in the future record tutorial for doing this report end to end?
@@jelenadj7289 Hello! You can follow along and build this exact report from scratch in my course, (in the description of this video). However, I will be creating more general / free content on TH-cam as well as long as this channel continues to grow and be supported.
Great method for both demonstrating and utilizing visual steps, thank you.💥💥
You're very welcome!
Sick! Thanks 🎉
Glad you like it!
@@nextlevelpowerbireports And would really like to see your video of explaining the calculate function :)
Superb explanation...
Thank you 👍
Superb explanation...
Thank you 😀
Hi! Thanks for the great videos you are creating! Is it possible to have one video explaining how to create a customized filter pane that can be displayed and hidden by the user to avoid to loose screen space?
Great suggestion!
Your animations combined with your description of what the DAX is doing (broken down into steps) is top notch. Multiple "thumbs up"!! Q: If I have a full featured date table with fields like year offset, month offset, month start, month end etc, do you think this would make the DAX simpler and faster?
Yes absolutely. If you already have offset fields in your data table, you can simply reference those fields (examples below) EXAMPLE 1 Gross Sales MoM% = VAR _CurrentMonthSales = CALCULATE( [Gross Sales], REMOVEFILTERS( DIM_Date ), DIM_Date[Month Offset] = 0 ) ) VAR _PreviousMonthSales = CALCULATE( [Gross Sales], REMOVEFILTERS( DIM_Date ), DIM_Date[Month Offset] = -1 ) ) etc.... EXAMPLE 2 = Gross Sales YoY% = VAR _Current12MonthSales = CALCULATE( [Gross Sales], REMOVEFILTERS( DIM_Date ), DIM_Date[Month Offset] <= 0 && DIM_Date[Month Offset] > -12 ) ) VAR _Previous12MonthSales= CALCULATE( [Gross Sales], REMOVEFILTERS( DIM_Date ), DIM_Date[Month Offset] <= -12 && DIM_Date[Month Offset] > -24 ) ) etc...
That's awsome! thanks
Glad you like it!
This is brilliant. Excellent explanation. Very enjoyable video. I’d love to see your version of the calculate function
Appreciate it! I'm glad you found it helpful,... I'll definitely consider adding a video on Calculate in the near future 👍
❤
Good. Thank you
Welcome 😊
Awesome work
Could you please make separate short video about how to maintain too many bookmarks From scratch ?
@@modatheralawad2983 will do! Great Suggestion 👍
And we eager to break down the measure as well
New video has been posted covering this!
So cool , wide knowledge plus cool Patience equal great works
@@modatheralawad2983 appreciate it!
Fantastic !!! thanks a lot .
Nicest Tutorial I ever seen, Thankyou sir
Thank you! I appreciate you.
Incredible !
Thank you!
Love jt
love that !
Awesome channel very informative
Thank you!
Awesome vedio, waiting for your next vedio. liked and subscribed
Thank you!
Useful information and best part is to provide a tutorial task for learning
Glad the tutorial was helpful to you 👍
Thank you so much, your videos are great. I hope you will publish more videos like this very soon
I appreciate the kind words. As long as this channel continues to grow and be supported, i will continue to make videos 👍
Top of the top
appreciate the kind words..thank you!
Data set link sir
@ragulmarley4900 Hello! The dataset and completed report is from my new course --> courses.nextlevelreports.com/order-form-14-days-to-mastering-power-bi-ux-ui-design-website-path However, you can practice these same techniques with any dataset you'd like. You would just have different measures. That's why I went through the background creation portion as well.
This is very nice
Thank you 😊
Clear. Thank u so much 😊
You're welcome 👍
What a great tutorial, love your teaching style TY!
@@tracywilliams61 I ppreciate that, thank you!
Am joining the course immediately
@@SabtechOnline use coupon code BLACKFRIDAY2024 😀
Great Informative video, thank you for the wonderful work. Yes, Pls make a video on Measure describing the whole measure in detail
Will do!
Can you provide full dataset sir. So that we can practise tooo
The dataset is from my new course ( courses.nextlevelreports.com/order-form-14-days-to-mastering-power-bi-ux-ui-design-website-path ) if you'd like to use the same report. However these techniques can be applied to any dataset you'd like.
Wow. You provided great step by step instructions. Please break down the time Intelligence measures to include YoY also.
Thanks...I'll make another video related to the measure 👍
I did this earlier, But I got a problem there. When I selected another page in page navigation and coming back to the same page. The navigation sub menu was still on. Is there any solution for this or it's a glitch.
I think the expected behavior with a back button is to go to the last state the user was in, so I personally think it's okay and they can close it. Unfortunately Power BI doesn't allow button on Hover effects just yet. We have a couple options here. You can simply delete the back button if needed. Then make sure each bookmark for each page view has the sub menu hidden / update those if needed. I personally wouldn't worry about it though as it still makes sense to see the sub menu when you click back. Another option is to create a navigation menu with html and css. I may try to create a video on this down the road. With this type you could have the sub menu open on hover instead of on click. Other than that I'm not sure of another way. Hope this helps. 👍
@nextlevelpowerbireports got it .Thanks
Yes, please breakdown the measure.
Will do!
Nice cards and nice tips......awesome !!
@@brenobrendalia7838 Thank you 👍
It´s a nice technique, but I´m struggling on navigation through pages once when I move back to the previous page the navigator page drop down is visible......I don´t know how to reset to the default state or even if it´s possible....
You mean after you press the back button?
@@nextlevelpowerbireports yeap....
@@brenobrendalia7838 i think the expected behavior with a back button is to go to the last state the user was in, so I personally think it's okay and they can close it. Unfortunately Power BI doesn't allow button on Hover effects just yet. We have a couple options here. You can simply delete the back button if needed. Then make sure each bookmark for each page view has the sub menu hidden / update those if needed. I personally wouldn't worry about it though as it still makes sense to see the sub menu when you click back. Another option is to create a navigation menu with html and css. I may try to create a video on this down the road. With this type you could have the sub menu open on hover instead of on click. Other than that I'm not sure of another way. Hope this helps. 👍
@@nextlevelpowerbireports thanks for your response....and many options provided you rock!!
love it. thanks bro
You're welcome 👍
Data source link
Link to the Udemy course is in the description. 👍
Absolutely phenomenal 👏
Thank you!
amazing man. one of the best PBI channels I know. keep going!!
Thank you...will do! 👍
Excellent
thank you!
could you please share your pbi file for praticing?
Hello! You can test these techniques out on any report honestly since it's more related to the settings and not the dataset. Your key insights just may be different, but the techniques are the same. However, if you wanted the exact report used in the video, it's from my course. Details here --> courses.nextlevelreports.com/14-days-mastering-ux-ui-design-website-path
which canvas setting do you set on your power bi vdo is it 6:9 ??
@@mintitatechatiumchan2348 16:9 (1280 x 720), which is the default. Just make sure PowerPoint is the same canvas size as well.