Next Level Power BI Reports
Next Level Power BI Reports
  • Видео 6
  • Просмотров 52 853
Master Power BI Bookmarks & Layer Grouping to Create Next-Level UIs!
🚀 Master Power BI Bookmarks & Layer Grouping to Create Next-Level UIs!
✨ Are you ready to WOW your stakeholders with app-like, modern, and intuitive Power BI reports? One of the secrets to crafting stunning user interfaces is mastering advanced bookmarks and layer grouping. This FREE advanced, in-depth, interactive tutorial will teach you everything you need to create seamless and powerful reports!
🧠 What You’ll Learn in This Video:
✅ Advanced bookmark techniques to create next-level Power BI UIs
✅ Mastering layers: grouping, naming, and ordering for organized workflows
✅ Bookmarking pro techniques: creating, using, naming, grouping, and ordering best practices
✅ Incorporating Bookmarks with Cu...
Просмотров: 2 743

Видео

Master Dynamic MoM & YoY % Variance DAX Measures in Power BI
Просмотров 4 тыс.14 дней назад
📊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 ...
Take your Power BI Cards to the Next Level - Full PBI UX/UI Tutorial
Просмотров 12 тыс.21 день назад
🎨 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
Просмотров 22 тыс.Месяц назад
🚀 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
Просмотров 9 тыс.2 месяца назад
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
Просмотров 4,4 тыс.Год назад
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

Комментарии

  • @sumithothuri8604
    @sumithothuri8604 7 часов назад

    Eager to see videos at least a weak.

    • @nextlevelpowerbireports
      @nextlevelpowerbireports Час назад

      If this channel continues to grow, i will be able to post more frequently. My goal right now is every two weeks. If you have been finding value, please feel free to share this channel or videos. I appreciate your support ! 👍

  • @sumithothuri8604
    @sumithothuri8604 7 часов назад

    Clear ...cool and simple. Great stuff @nextlevelpowerbireports.

  • @escopetadoce
    @escopetadoce 23 часа назад

    Thanks for all your videos. I have implemented some of the bookmarks shown here: One page, same visuals, two different table sources, bookmarks hide/show the visuals. As for the "Current Page", I was wondering if there was a way to change the visual of another page without focusing on that page. This helps on the following use case: Tooltip! When hovering over a visual, allow the user to select, before hovering, what information to display when they hover over a certain visual. It will probably be better to have those visual on the same page, but when real estate is limited, a tool tip with selectable visuals can do the trick, and this could be the answer.

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 20 часов назад

      Your're welcome 👍 And user selected Tooltips sounds like great example use case for having "Current Page" unchecked!

  • @02muthukumar
    @02muthukumar День назад

    Thank you for sharing your knowledge. Just wanted to know if you are using updated version of POWERBI, as i see many fields are interchanged in my system, as a new learner to Powerbi, I find it Little difficult to navigate. It would be of Great help if you could use the updated version and have complete beginner to pro level training on powerbi.

    • @nextlevelpowerbireports
      @nextlevelpowerbireports День назад

      Hello...this is the latest version. I'm guessing you have "On object Interaction" enabled. I do not like that feature so I choose to leave it unchecked. Note that is a Preview Feature and not the default.

    • @02muthukumar
      @02muthukumar 22 часа назад

      @@nextlevelpowerbireports Thank you for clarifying! I checked, and you’re right-the On-object Interaction feature was enabled on my system, which caused the difference. After disabling it, my interface now matches yours perfectly. As a beginner, I found the On-object Interaction feature a bit confusing, but I’d be curious to know your thoughts on whether it’s worth exploring. Do you think it offers meaningful advantages for users? If not, I’m happy to continue learning with the standard setup you’re using. Thanks again for your guidance and detailed tutorial.

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 20 часов назад

      @@02muthukumar I personally don't like it. I think the default way is cleaner and faster. Like I teach in my course, simplicity is best. Specifically, I prefer all panes to right-hand side. To me it just makes the most sense. I don't know why other courses teach with this enabled. It's a preview feature, not default. Of course, this is just my personally opinion. Everyone is different.

  • @nextlevelpowerbireports
    @nextlevelpowerbireports День назад

    If you are curious how I tweaked the Units Sold Visuals to Gross Sales, you can check out this 3min video here --> ruclips.net/video/FtKxFr_zn6Q/видео.html If you found this tutorial helpful, please feel free to like, share, and subscribe. Note if your settings don't match, it may be because you have "on object Interactions" on. I do not like that preview feature. I feel the default is cleaner and easier to use. To follow along, simply uncheck that features and restart Power BI. Thank you!

  • @mhn_in
    @mhn_in 2 дня назад

    How to tweak in to gross sales view I didnt get ur point on it And u didnt meantion the name on gross sales after filtering right??

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 2 дня назад

      @@mhn_in after you duplicate the layer group, you simply adjust your two buttons, card, and two charts to be blue and have the measure gross sales in it. The button colors would flip, so units sold button now becomes gray and gross sales button becomes blue. ( in this example ). Here's the link to to seeing how I tweaked that duplicate group --> ruclips.net/video/FtKxFr_zn6Q/видео.html

    • @mhn_in
      @mhn_in 2 дня назад

      sure, im intrested Iam waiting For ur update on it

    • @nextlevelpowerbireports
      @nextlevelpowerbireports День назад

      @@mhn_in Here you go --> ruclips.net/video/FtKxFr_zn6Q/видео.html

  • @AbdulQadir-fg1cf
    @AbdulQadir-fg1cf 3 дня назад

    great stuff, can you provide dataset to practice along

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 3 дня назад

      Thank you! I use a simple example in this video so you could follow the steps on your own dataset with any visuals. All you need to do is make the two buttons as well. Then follow the steps of duplicating the group etc. That being said, this exact dataset and example is provided in my "14 Daya to Mastering Power BI UX/UI Design " course if you want the exact dataset and to see the completed example uaed.

  • @suryatej839
    @suryatej839 3 дня назад

    Bro Please make videos regularly , atleast once in a week, you have claered all my doubts on Bookmarks

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 3 дня назад

      I'm glad you found this helpfull ! 👍 If this channel grows large enough (need help from people like you sharing 😀 ), i can hopefully get to once a week. My goal right now is one every two weeks.

  • @D4rkm00r
    @D4rkm00r 3 дня назад

    Hello. You're cool. Can i be your friend!? Banter aside, your work has a great eye for detail and I'm excited to try something this polished.

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 3 дня назад

      Glad you found this helpful! Feel free to connect with me on LinkedIn if you'd like 👍

  • @suryatej839
    @suryatej839 3 дня назад

    Superb bro tq u for great explanation.

  • @workstuff5253
    @workstuff5253 3 дня назад

    I was lazy (and a little scared of complex bookmarks), so I duplicated the pages to navigate between them to make it look like a report page with a filter page over the top.

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 3 дня назад

      Well i hope this video was helpful! Most reports will not ever need the type of Bookmarking I'm showing at the end of this video. However it's great to understand these techniques so you can have more flexibility in your reports if and when needed.

  • @workstuff5253
    @workstuff5253 3 дня назад

    Great explanation!! The MS naming for some of the bookmark options is shocking!

  • @reddyprasad2484
    @reddyprasad2484 3 дня назад

    It's very clear thank you

  • @ragulmarley4900
    @ragulmarley4900 3 дня назад

    Data set link sir

    • @nextlevelpowerbireports
      @nextlevelpowerbireports День назад

      Hello! I purposely used a simply example so you could practice these techniques with any data set. Simply create two measures such as sum of units sold and sum of gross sales. However, if you wanted use the exact dataset and/or see this exact report, feel free to check out my course at the link here --> courses.nextlevelreports.com/14-days-mastering-ux-ui-design-website-path

  • @seedmatrix
    @seedmatrix 3 дня назад

    I’ve done a little bit with bookmarks, but my is blown with what you’ve shown. This is amazing. I’ve got the perfect report to use this with. Thank you.

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 3 дня назад

      Yeah, bookmarks are pretty powerful when you know how to use them. The key is staying organized. I'm glad this was helpful 👍

  • @sourabhpatel3834
    @sourabhpatel3834 3 дня назад

    Is Putting so many visuals on a single page will degrade performance?

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 3 дня назад

      Hidden Visuals do not impact performance. They aren't processed until shown.

  • @Thelittleethanpaul
    @Thelittleethanpaul 3 дня назад

    Which version are you using?❤ Nicest tutorial

  • @getsetgoo3334
    @getsetgoo3334 3 дня назад

    This is the best tutorial I've found! 📚 I learned all the bookmark functionalities with clear examples. 🌟 Truly excellent! 👍

  • @djaleleddineboussahel1501
    @djaleleddineboussahel1501 6 дней назад

    perfect man !! thank you alot

  • @Ghanaba-ow4mr
    @Ghanaba-ow4mr 6 дней назад

    How was the reporting period created?

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 6 дней назад

      Hello, The Reporting period is simply a Month Year field in the calendar table with a data type as "Date". You can change the format in Power BI (IE: 12/1/2024, Dec. 2024, etc.)

  • @Ghanaba-ow4mr
    @Ghanaba-ow4mr 7 дней назад

    Great explanation to a complex concept. If we don’t have a completed month but want to compare the latest completed month to the prior month, how exactly is that taken into account in the DAX formula?

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 6 дней назад

      Hello! You would simply increase how far you want to go back by 1. IE: Variance Period MoM (-1) = VAR _LatestVisiblePeriod = MAX( DIM_Date[Reporting Period] ) VAR _MonthStart = CALCULATE( MIN( DIM_Date[Date] ), DIM_Date[Reporting Period] = _LatestVisiblePeriod ) VAR _PreviousCompletedMonth = CALCULATE( MAX( DIM_Date[Reporting Period]), REMOVEFILTERS( DIM_Date ), DATESBETWEEN( DIM_Date[Date], EOMONTH( _MonthStart, -3 ) + 1, EOMONTH( _MonthStart, -2 ) ) ) VAR _LatestCompletedMonth = CALCULATE( MAX( DIM_Date[Reporting Period] ), REMOVEFILTERS( DIM_Date ), DATESBETWEEN( DIM_Date[Date], EOMONTH( _MonthStart, -2 ) + 1, EOMONTH( _MonthStart, -1 ) ) ) VAR _Result = "MoM% | "&FORMAT( _LatestCompletedMonth,"mmm YY" ) &" vs "& FORMAT( _PreviousCompletedMonth,"mmm YY" ) RETURN _Result

  • @ttmaykon
    @ttmaykon 7 дней назад

    Awesome!

  • @ashutoshpagariya
    @ashutoshpagariya 7 дней назад

    Do you have any course for DAX queries?

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 6 дней назад

      I do review the Variance measures in depth (link below). However, if you're looking for a general course, no, I don't. If there is a DAX concept you'd like me to cover though feel free to let me know. ruclips.net/video/B0KRfybXvh0/видео.html

  • @ttmaykon
    @ttmaykon 7 дней назад

    Amazing!

  • @jesusdariomosquera7762
    @jesusdariomosquera7762 11 дней назад

    WAOOO AMOIGO EXCELENTE GRACIAS

  • @VonMellArevalo
    @VonMellArevalo 11 дней назад

    You should show us those DAX MEASURE TO GIVE US IDEA OF TWHY IS IT INCLUDED IN THE REPORTS

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 11 дней назад

      Here you go ruclips.net/video/B0KRfybXvh0/видео.htmlsi=L2gAGGTbGMD1KB-8

  • @IloabuchiifechukwuDavid
    @IloabuchiifechukwuDavid 12 дней назад

    Thanks sir Please make a complete tutorial on this project

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 11 дней назад

      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

  • @ragulmarley4900
    @ragulmarley4900 13 дней назад

    Sir kindly upload 😊 basic to advanced video in bi 😊 really helpful

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 11 дней назад

      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

  • @tinaflemons263
    @tinaflemons263 13 дней назад

    The indepth instructions you provided are phenomenal. I'm bookmarking this in my favorites.

  • @alono2323
    @alono2323 13 дней назад

    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).

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 13 дней назад

      @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

  • @jelenadj7289
    @jelenadj7289 13 дней назад

    Will u maybe in the future record tutorial for doing this report end to end?

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 13 дней назад

      @@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 RUclips as well as long as this channel continues to grow and be supported.

  • @getsetgoo3334
    @getsetgoo3334 14 дней назад

    Great method for both demonstrating and utilizing visual steps, thank you.💥💥

  • @andersborglund2287
    @andersborglund2287 14 дней назад

    Sick! Thanks 🎉

  • @Ratnakumarwrites
    @Ratnakumarwrites 14 дней назад

    Superb explanation...

  • @Ratnakumarwrites
    @Ratnakumarwrites 14 дней назад

    Superb explanation...

  • @fla1910
    @fla1910 14 дней назад

    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?

  • @workstuff5253
    @workstuff5253 14 дней назад

    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?

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 13 дней назад

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

  • @patrickharilantoraherinjat2994
    @patrickharilantoraherinjat2994 14 дней назад

    That's awsome! thanks

  • @joelabacherli1310
    @joelabacherli1310 14 дней назад

    This is brilliant. Excellent explanation. Very enjoyable video. I’d love to see your version of the calculate function

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 13 дней назад

      Appreciate it! I'm glad you found it helpful,... I'll definitely consider adding a video on Calculate in the near future 👍

  • @qasimjan5258
    @qasimjan5258 14 дней назад

  • @vovk_oleg
    @vovk_oleg 14 дней назад

    Good. Thank you

  • @lukev730
    @lukev730 17 дней назад

    Awesome work

  • @modatheralawad2983
    @modatheralawad2983 18 дней назад

    Could you please make separate short video about how to maintain too many bookmarks From scratch ?

    • @nextlevelpowerbireports
      @nextlevelpowerbireports 18 дней назад

      @modatheralawad2983 will do! Great Suggestion 👍 UPDATE...I just published this 😉

  • @modatheralawad2983
    @modatheralawad2983 18 дней назад

    And we eager to break down the measure as well

  • @modatheralawad2983
    @modatheralawad2983 18 дней назад

    So cool , wide knowledge plus cool Patience equal great works

  • @javosky11
    @javosky11 18 дней назад

    Fantastic !!! thanks a lot .