Power BI Native Progress Bar | Create Progress Bars Without Custom Visual or SVG in Power BI

Поділитися
Вставка
  • Опубліковано 11 вер 2024
  • We will Use some DAX Tricks to enable Progress Bar using Power BI Line charts. This technique is helpful in case you are not allowed to use custom visuals in your organization.
    Get Help into Questions Related to #powerbi, #dax, #powerquery Power BI #datamodeling, #analysisservices and #powerbiservice and #microsoftfabric
    Check out our website www.powerbihelpline.com and blog-post. for end-to-end power BI solutions, Power BI templates, or any kind of Power BI questions like Power query errors, Authoring and optimizing DAX codes for complex business logic.
    Follow us on LinkedIn
    / power-bi-helpline-22a2...
    Email- info@pbihelpline.com
    @PowerBIHelpline

КОМЕНТАРІ • 41

  • @anilkapkoti296
    @anilkapkoti296 Рік тому +2

    Just amazing...🎉🎉
    There is no doubt that one day you will be the leader in youtube for power bi contain.

    • @PowerBIHelpline
      @PowerBIHelpline  Рік тому

      Wow! Thank you so much for showing such a great confidence and interest in our contents.

  • @dawidbrzeski9176
    @dawidbrzeski9176 Рік тому +1

    wow, it was truly out of the box thinking example 🤜

  • @adipro03
    @adipro03 Рік тому +1

    One word: AMAZING

  • @mnowako
    @mnowako 5 місяців тому +1

    What a great lesson, thx!

  • @patricefayard2626
    @patricefayard2626 Рік тому +1

    Bravo. You are so great and thanks for the sharing.

  • @rajeshkhanna-ew6eb
    @rajeshkhanna-ew6eb 4 дні тому

    Amazing tutorial

  • @guilhermebastos5685
    @guilhermebastos5685 Рік тому +3

    Incredible video, simply the best on the internet.
    I repeat your steps, however my "Data Point" does not appear on the graph, could you help me with a solution?

    • @PowerBIHelpline
      @PowerBIHelpline  Рік тому

      Thanks for the appreciations. If you want to get the PBIX file, send an email to info@pbihelpline.com with video title as email subject.

    • @guilhermebastos5685
      @guilhermebastos5685 Рік тому

      @@PowerBIHelpline I sent you my email

    • @gonsite
      @gonsite 4 місяці тому

      @@guilhermebastos5685 same here, no data point in visual and also 3rd slab is not shown

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

    Where is the budget utilization % coming from? I tried to bring in a different data set as it seems like this was done but in the formula I cant access that value

  • @yallamandab7976
    @yallamandab7976 9 місяців тому

    Very good details view project

  • @arbazahmad7177
    @arbazahmad7177 Рік тому

    Excellent 🎉 thanks for sharing

  • @user-eb5sj7ip5r
    @user-eb5sj7ip5r 4 місяці тому

    How to add CF for this i want data bar to be green until it reaches the target and beyond that to be red. How to do it?

  • @guppi1
    @guppi1 6 місяців тому

    Great tricks. But there is one problem, in this visual we are setting up the target at 80%. If we use this visual as target performance analysis, there will be a confusion.
    If the target achievement is greater than 80% but less than 100% (let say 91%), the data point indicates that we are achieving (achievements is greater than the target line) even though we don't.
    How to overcome that problem?

    • @guppi1
      @guppi1 6 місяців тому

      I found a way. I just make the axis line longer than 100% (say 150%) and then set the target to 100%

  • @user-uy4hh5ul1c
    @user-uy4hh5ul1c Рік тому +1

    Thanks for sharing, However my data point is not visible.

    • @PowerBIHelpline
      @PowerBIHelpline  Рік тому

      I can understand that if you miss any part of the formatting, you would not get the required functionality. Please make sure you haven't missed any step. if required, you can send an email to get the PBIX file used in the demo

    • @sanskar21
      @sanskar21 9 місяців тому +4

      IF( MAX('Progress Bar'[Axis])=ROUND([Budget Utilization %],2),17,BLANK())
      You're welcome

    • @GopherzHockey
      @GopherzHockey 7 місяців тому

      Thanks, I had to apply this as well.@@sanskar21

  • @benbabani2986
    @benbabani2986 5 місяців тому

    Thanks for sharing. I can't find the error bar section. I am using PBI version from Nov 2023

    • @hardiwiyonofamily6228
      @hardiwiyonofamily6228 5 місяців тому

      same here

    • @FelipeQueiroz-og4uc
      @FelipeQueiroz-og4uc 5 місяців тому +1

      It is not in the visuals or format section, the bar error is in that magnifying glass
      section. Look it up, I found mine after a while

  • @abhi007mehta
    @abhi007mehta 3 місяці тому

    Will it work for targets and if target achieved is more than 100%

    • @PowerBIHelpline
      @PowerBIHelpline  3 місяці тому

      Yes, you can adjust the measures accordingly

  • @user-tc6ev1ol8x
    @user-tc6ev1ol8x 11 місяців тому

    Can we do this just to share milestone in dates format ?

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

    Very creative, but DAX and audio explanations are too fast to grab and understand. I have to rewind several times to get the concept. Anyway, great video.

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

      Great suggestion! Thanks for providing your valuable input.

  • @abdirazaksuldan21
    @abdirazaksuldan21 11 місяців тому

    Great video. Can you share the file

    • @PowerBIHelpline
      @PowerBIHelpline  11 місяців тому

      To get the PBIX file used in the demo, you can send an email by mentioning the video title as email subject

  • @radizetv7334
    @radizetv7334 2 місяці тому

    Please share the file use.. email sent thank you

  • @Greg-dn5rt
    @Greg-dn5rt 11 днів тому

    You are going too fast