3 Hacks to Work Faster in Power BI

Поделиться
HTML-код
  • Опубликовано: 10 янв 2025

Комментарии • 101

  • @datadataeverywhere6954
    @datadataeverywhere6954 11 месяцев назад +36

    Ever since I started implementing your visualization ideas and technique, my boss has been really happy with the visualizations I create, Man I cant thank you enough.

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад +2

      Nicceee!!! happy to hear that 👊

    • @JustJoeking87
      @JustJoeking87 8 месяцев назад +1

      ​@@HowtoPowerBI Man we all love your passion bro. Thanks a billion.

  • @mackhazelwood
    @mackhazelwood 10 месяцев назад +1

    You have video or can point me towards visual used for the sales performance bars bubbles @19:12 they are so slick! Perfect for something I am working on.

  • @walterstevens8676
    @walterstevens8676 3 месяца назад

    Perhaps it's my level of development as a Power BI person, but this sort of video is extremely valuable to me, thank you.

  • @davidm00ris
    @davidm00ris 11 месяцев назад +4

    Game changer lessons for me on the custom JSON file. This is amazingly helpful. Already implemented my first custom JSON with all of my normal standards. This is so great. THANK YOU!

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      Awesome 😎👍Straight away to implementation

  • @willshaq1
    @willshaq1 11 месяцев назад +5

    Parabéns Mestre!
    A comunidade do Brasil agradece.

  • @davidmcdonnel4831
    @davidmcdonnel4831 9 месяцев назад +2

    I use the Power BI Sidetools extension. It creates a folder structure for the pbix with all the table definitions, measures, and a layout model/bim. Saving measures to github would be as easy as using the extensions "save to visual studio code" button, then doing a git push on the existing folder.

    • @davidmcdonnel4831
      @davidmcdonnel4831 9 месяцев назад

      The great thing is this makes every visual and data model change readable. If you are regularly committing these changes to git, you can easily revert, mix and match, or reuse without even opening PBI Desktop. Once you've made your changes in Visual Studio Code, there's an option to save the changes back to the pbix file.

  • @francescaepifania4651
    @francescaepifania4651 11 месяцев назад +4

    I love your videos, always very very useful! Thanks!

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      😁 very happy hear that , thx for watching them

  • @cromeromail
    @cromeromail 11 месяцев назад +1

    Thank you! You have leveled me up 20 times over!

  • @juanignacioXI
    @juanignacioXI 12 дней назад +1

    Pure gold Bas, thank you 🎉

  • @SVAL_5371
    @SVAL_5371 11 месяцев назад

    I just started following your channel. The content is thought out and explained in a way which is concise and easy to understand. I appreciate your going a bit deeper into the more challenging content as well.

  • @PawanKumar-nh3pi
    @PawanKumar-nh3pi 11 месяцев назад +3

    Pls suggest an good datenpicker visual with date formatting, easy range selection with calender view. Powviz date picker is not working in my published report, says it cant work in the environment

  • @Thiago.M082
    @Thiago.M082 11 месяцев назад +1

    Valeu!

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      thank you so much for the support!!! 😁

  • @jesslmzn3072
    @jesslmzn3072 9 месяцев назад +1

    This is such a life saver! Thank you!

  • @ronaldtijssen7492
    @ronaldtijssen7492 11 месяцев назад +1

    Great video as usual. I love your video’s and use a lot of your ideas. This video is an eyeopener. I allready wanted to do something with JSON files but now I know where to start. And your tips about add-ins and Github…. I’d love to get started with. Thanks a lot.

  • @workstuff5253
    @workstuff5253 11 месяцев назад

    Great tips - Thanks!
    I see @4:29 the AboveAvg measure and the MinMax before it uses a calculate function wrapped around the [Total Sales] measure. I thought a measure reference had an implicit calculate. I am still struggling with DAX, so could you explain why this is the case?

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад +2

      Yes, correct :) you don't have to put the calculate around a measure (was from a different example file) - a lot of people would take the file and then write sum(salescolumn) instead of a measure and then it wouldn't work.. that's why I left the calculate there

  • @brandymoran9646
    @brandymoran9646 11 месяцев назад

    What an amazing video!! I especially loved the first part, since I’m just now getting to where I keep using the same measures over and over!

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад +1

      Especially awesome after some time when you have a whole treasury of useful code templates ;)

  • @chrism9037
    @chrism9037 11 месяцев назад +2

    Excellent video, thank you!

  • @raphaaurabi
    @raphaaurabi 9 дней назад

    Hi Bas, thanks a lot for your amazing videos, they’ve been really helpful! I have a question:
    How can I change the background color in Focus mode for visuals in Power BI?

    • @HowtoPowerBI
      @HowtoPowerBI  8 дней назад +1

      i dont think that's possible.. unfortunately :(

  • @nzlnzl
    @nzlnzl 8 месяцев назад

    This is huge lifesaver. Thank you!

  • @danielascibilia4608
    @danielascibilia4608 11 месяцев назад

    Noted! I’ll start to looking for the right external tool to be added to my power bi🤗 Thanks a bunch for your awesome recommendation! I really need to save more time in the process 😅

  • @shankarmidatala2049
    @shankarmidatala2049 3 месяца назад

    Hi Bas, Thanks for the video, I follow your videos for my learning. I've a question - how do you get Data, Visualization, Format, Bookmarks as buttons on the right side of the screen?

  • @vishalnasre1251
    @vishalnasre1251 11 месяцев назад

    Wonderful Bas. Thanks for the video, specially for the customer theme option.

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      thank you !! yes having a few good themes make it a looooot easier for the front end design

  • @byrongallegosmarcillo7158
    @byrongallegosmarcillo7158 11 месяцев назад +1

    Very useful as always!! Thank you!

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      thanks for watching! 😊

  • @mtavassoti
    @mtavassoti 11 месяцев назад +1

    Thank you so so much for amazing videos. Keep up the great work ❤✨️

  • @emilmubarakshin49
    @emilmubarakshin49 11 месяцев назад

    This is solid gold. Generalizing and customizing🎉🎉🎉. Thank you

  • @judeLondon
    @judeLondon 10 месяцев назад

    Hello buddy. I tried to find the file content associated to the video but there are too many links and registration to your IO website only lead to links pointing to the RUclips videos for this particular one. Any clues on the PBI file you copied the MinMax dax from etc ? thanks

  • @alessandro_df
    @alessandro_df 11 месяцев назад

    Such a useful video, thank you!! Do you have any plan of making a video about the most useful powerbi add-ins you use?

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      Thx for idea!!💡 yes maybe 🤔 will think about it

  • @josefedericopresno6668
    @josefedericopresno6668 11 месяцев назад

    Great Hacks, Bas!
    Thank You very much for another helpful video

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      Glad you like them! 😁😁

  • @yullisko
    @yullisko 11 месяцев назад

    Is it possible to set the default number of decimals for all values in the report anywhere? I mean, not for only one visual but for all?

  • @sivasankari-n8q
    @sivasankari-n8q 11 месяцев назад

    you're absolutely great,many thanks to you

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      So nice of you, thank you!

  • @chaithraramesh2196
    @chaithraramesh2196 11 месяцев назад +1

    Cam you please make a video on testing the reports after development using automation

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад +1

      thanks for the idea! :) will think about it

  • @sauravkragrawal
    @sauravkragrawal 11 месяцев назад

    Is there a website wherein readymade python codes are available and is tere a website where such codes can be sold?

  • @just_pbi
    @just_pbi 11 месяцев назад

    Thank you for the awesome tips Bas! However, I'm having difficulty installing MSHGQM, I'm running Windows 11 and I keep getting the error "This Installation package could not be opened" Can you perhaps guide me on how to install it please?

  • @mohamedfouad7958
    @mohamedfouad7958 9 дней назад

    Thaaaaaaaaaaaaaaaaaaaaaaaaaaanks a lot for the great job and all your explained hacks in this video

    • @HowtoPowerBI
      @HowtoPowerBI  8 дней назад

      hope they help a bit! 💪💻😁 thx for watching

  • @Zowie-1111
    @Zowie-1111 11 месяцев назад

    Amazing! So useful 👌

  • @unnikrishnansanthosh
    @unnikrishnansanthosh 11 месяцев назад

    Master BAS, thank you for sharing

  • @Esmidoen
    @Esmidoen 11 месяцев назад

    Hi Bas. What are your thoughts on using figma with PowerBi - in terms of design and UI?

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      its nice, but just another tool :) .. whatever you feel comfortable with and let's you create the design you have in mind.. for many people powerpoint is enough

  • @sreeraga441
    @sreeraga441 10 месяцев назад

    What is 'QuarterNo' in the dax measure for MaxMin. Can you share the formula ?

    • @HowtoPowerBI
      @HowtoPowerBI  10 месяцев назад

      that's the sortby column for quarter name (if you use all / allselected you need to put in the sortby column as well)

  • @edwinarchico439
    @edwinarchico439 11 месяцев назад

    This is amazing, saves me a lot of time in development, many thanks Bas!

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      Definitely does for me , if u share ur code / design assets with team members you save even more time

  • @thatdatachick6503
    @thatdatachick6503 11 месяцев назад

    Can you do a video on how to filter one field parameter slicer based on a different parameter field slicer? For instance, if my first parameter field contains Program, Teacher, Student and I select Program, I only want my second parameter field slicer to return Teacher and Student. The idea here is to allow users to determine the breakdown in a matrix. For example: See averages based on Program then Student or see averages based on student then program. I've searched and searched trying to figure out how this can be done. Thank you.

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      Here you go :) ruclips.net/video/nWgPynP9XDM/видео.htmlsi=toNDekr2Y4zNWPVK

  • @charlesdelanoy
    @charlesdelanoy 11 месяцев назад

    Great thanks :)

  • @satishkumardommeti8282
    @satishkumardommeti8282 11 месяцев назад

    Just superb..❤

  • @vinaykumarsingh8744
    @vinaykumarsingh8744 10 месяцев назад

    Please create videos on power bi cloud services environment

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

    Don't you have a folder with the ones you use to share with us? 🤔

  • @AbouAli01006300091
    @AbouAli01006300091 11 месяцев назад

    Suuuuuuuuper like !!

  • @PawanKumar-nh3pi
    @PawanKumar-nh3pi 11 месяцев назад

    How can w have a dynamix totals linenin line chart appart from individual line for each legend

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад

      don't understand the question, sry

    • @PawanKumar-nh3pi
      @PawanKumar-nh3pi 11 месяцев назад

      @@HowtoPowerBI sorry when we use a line chart, it shows values only for each field item. I want an additional line showing totals. I dont want to use stacked area charts

  • @nikolagrkovic8769
    @nikolagrkovic8769 11 месяцев назад +1

    Very first measure you copied... MaxMin. Why did you put CALCULATE([Total Sales])??? Why is there a CALCULATE wrapping a measure?

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад +9

      the calculate is not necessary .. but often people would copy the code they see as in the file / video and then replace the measure with SUM(sales[amount])) , which doesnt invoke context transition and would need a calculate around it

    • @nikolagrkovic8769
      @nikolagrkovic8769 11 месяцев назад

      @@HowtoPowerBI Wow, that's cool

  • @sukoi2113
    @sukoi2113 11 месяцев назад

    So so lovely.

  • @meena2umasankar
    @meena2umasankar 11 месяцев назад

    ❤❤❤❤❤

  • @Steven140695
    @Steven140695 11 месяцев назад

    it's not a tons of time... megatons 😄

    • @HowtoPowerBI
      @HowtoPowerBI  11 месяцев назад +1

      😄 yes will say megatons next time lol

  • @भाईजॉन
    @भाईजॉन 11 месяцев назад

    Wha goree