Hacking a Donut or Stacked Bar Chart in Power BI to Create a Killer KPI Card

แชร์
ฝัง
  • เผยแพร่เมื่อ 22 ธ.ค. 2024
  • Are you looking for ideas to create KPI visuals that measure against a target or the part of a whole, and don’t fancy using the dreaded gauge chart?
    Do you want to add in some dynamic measures to provide insightful context?
    And do you also want to apply colour formatting and some visual flourishes to set it off?
    Is the answer is yes, yes, yes, then you have the right video.
    I am going to show you how to do all three and show a few lesser known work arounds or hacks in the process to enable you to create the below options, and maybe spark your own creative process.
    The data model file is linked below if you want to follow along, and the medium link below shows the walkthrough steps and calculations.
    Follow for more Power BI advanced tips and tricks.
    Data Model Link: drive.google.c...
    📱 SOCIAL MEDIA
    LinkedIn: / gerard-duggan-15420a55
    Twitter: @DGAnalysis
    📔 BLOGS & WRITING
    Medium: / hacking-a-donut-or-sta...
    DG-Analysis: dg-analysis.com/
    Maven Showcase: mavenanalytics...

ความคิดเห็น •

  • @idontknowexcel
    @idontknowexcel ปีที่แล้ว +3

    Here from one of your comments on Redditt. Now a subscriber.

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Thanks, welcome 🙏

  • @zachariahvercruyssen5305
    @zachariahvercruyssen5305 ปีที่แล้ว +2

    Excellent job. I rarely find videos this helpful

    • @dganalysis
      @dganalysis  ปีที่แล้ว +1

      Thanks, glad it was helpful - gives incentive to make more if it is something people are looking for.

  • @musariololade2204
    @musariololade2204 7 หลายเดือนก่อน +2

    Fantastic work. Learned so much from the hack. Your explanation and simplicity of writing the DAX measures really made me understand a lot. Kudos. Looking forward to learning more from you. Would be applying this on a live project in the coming days.

    • @dganalysis
      @dganalysis  7 หลายเดือนก่อน

      Thank you 👍

  • @OlgaGromova-x3o
    @OlgaGromova-x3o ปีที่แล้ว +1

    its perfect video for beginners! i wached it maybe 100 times)) and will watch again and again for better understanding. Thank you so much. its beautiful, very smart and very intresting! wanna more ))))

  • @workstuff5253
    @workstuff5253 ปีที่แล้ว +3

    I love these process style videos. Great content as usual!! Thank you

    • @dganalysis
      @dganalysis  ปีที่แล้ว +3

      Thanks. I know these are a little longer than most other types of videos, but I think it's useful to show start to finish.
      If there is an appetite for them, I will keep making them.

    • @karinamatvejeva3164
      @karinamatvejeva3164 ปีที่แล้ว

      Yes, yes, we have appetite for them 😊😂thank you

  • @imstillbreathing1
    @imstillbreathing1 ปีที่แล้ว +1

    Great Work!!! I love how creative your ideas are.

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Thanks, working on some more...

  • @albedoguardian875
    @albedoguardian875 6 หลายเดือนก่อน +1

    Underrated Gem 💎

    • @dganalysis
      @dganalysis  6 หลายเดือนก่อน

      Thanks, appreciate it 👍

  • @jaidevsolanki2259
    @jaidevsolanki2259 ปีที่แล้ว +1

    Very well explained. Thanks

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Thank you Jaidev, appreciate the feedback

  • @marie-annemelis188
    @marie-annemelis188 ปีที่แล้ว +3

    Lots of goodies in this video (and in the PBIX if you hate creating datetables) 👍

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Yes, I decided to use a single dataset for a series of videos. Makes it easier for people to follow along if they wish to.

  • @mindaugasseka
    @mindaugasseka ปีที่แล้ว +1

    superb charts! Thank you!

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Glad you like them!

  • @emilyamalkin4367
    @emilyamalkin4367 ปีที่แล้ว +1

    Great content! Liked and subscribed 👍🏻

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Thank you, appreciate the support. Glad you liked it

  • @abdulmalekalsaati4856
    @abdulmalekalsaati4856 ปีที่แล้ว

    Very creative and helpful, thank you for sharing.

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Thanks, my pleasure

  • @woodleygeneus1537
    @woodleygeneus1537 ปีที่แล้ว +1

    Thank you for sharing this very informative video.

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      You are very welcome

  • @ragragrec1
    @ragragrec1 ปีที่แล้ว +1

    Killer stuff as always. thankyou

  • @khaoa7214
    @khaoa7214 ปีที่แล้ว +2

    What's the significance of adding an underscore before your measures table?
    I see it sometimes with DAX functions also, that people will use an underscore beforehand as some sort of convention.
    Youre a bro for dropping this sort of quality content, thanks a lot

    • @dganalysis
      @dganalysis  ปีที่แล้ว +1

      It means it will come at the top of the pane, as it will ignore alphabetical order.
      You could use numbers instead, I see some people number their key measures.

  • @tinaflemons263
    @tinaflemons263 ปีที่แล้ว +1

    Love your content

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Thank you Tina, appreciate it 🙌

  • @fabianbartasco6391
    @fabianbartasco6391 ปีที่แล้ว +1

    Cool stuff. Im new at pbi but Im gonna give it a try

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Nice, if there are things you would like me to explore in future videos, let me know.

  • @JoséAlmeida-v1g
    @JoséAlmeida-v1g 17 วันที่ผ่านมา +1

    it is better than most of payed courses, kinda cheated using between as data but feels better on my workplace

    • @dganalysis
      @dganalysis  16 วันที่ผ่านมา

      @@JoséAlmeida-v1g thank you for the feedback, glad it helped

  • @BestICan
    @BestICan ปีที่แล้ว +2

    Well done! Is there no way to use a Switch statement for the KPI band scores rather than creating four separate measures?

    • @dganalysis
      @dganalysis  ปีที่แล้ว +2

      Yes, you could use switch instead of the if statement, but you still need multiple measures as you need to be able to assign one colour per measure manually in the format pane.
      If conditional formatting was allowed for the colour, I would use one switch statement.
      If you see my other videos on colour formatting,that is what I use.
      Thanks 👍

    • @BestICan
      @BestICan ปีที่แล้ว +1

      @@dganalysis Thanks!

  • @resendizgranadosbrandonemm1197
    @resendizgranadosbrandonemm1197 ปีที่แล้ว +1

    How to make the cards not go behind the graphic and always stay on top of the visual element that we want to put behind them?

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      If I understand correctly, using the selection pane to arrange the order of the layers on visuals

  • @Mr97Frog
    @Mr97Frog 9 หลายเดือนก่อน +1

    May I know the color scheme for your pbi?

    • @dganalysis
      @dganalysis  9 หลายเดือนก่อน

      There is a link to download the file. You should see the colour scheme in there.

  • @NdexSystems
    @NdexSystems ปีที่แล้ว

    My pie chart interactions are not functioning as expected. When the target revenue is > then the max revenue my pie chart displays correctly when using KPI % and 1 - KPI data points for chart. If target revenue is < then the max revenue the chart displays the KPI as the % of target instead of % of max. Also the 4 color bands all show as 100% in the pie chart. My table functions fine but the pie chart is not cooperating. Not sure is anyone else encountered this.

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Not sure if there is a way to screen shot your viz and send? I assume the calculations have been added in the correct order on the donut charts?

  • @AliAbbas-ik9ix
    @AliAbbas-ik9ix ปีที่แล้ว +1

    excellent May Allah Bless you Ameen.

  • @francisthegeek
    @francisthegeek ปีที่แล้ว

    the eyes though!

    • @francisthegeek
      @francisthegeek ปีที่แล้ว +1

      Amazing & very useful content as always. More of this, Senpai!

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      My eyes? 😅

  • @gopyjs6216
    @gopyjs6216 ปีที่แล้ว

    Am I the only one who is facing issues with audio?

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Accent or volume?

    • @gopyjs6216
      @gopyjs6216 ปีที่แล้ว +1

      @@dganalysis Volume is too low and not able to follow

    • @dganalysis
      @dganalysis  ปีที่แล้ว

      Ok, sorry about that, the volume is ok on my computer

    • @gopyjs6216
      @gopyjs6216 ปีที่แล้ว

      @@dganalysis Oh fine. tq

    • @yogamayaa
      @yogamayaa 8 หลายเดือนก่อน

      @@dganalysis Volume is really low inspite of keeping the settings at the highest level.

  • @petertrnka459
    @petertrnka459 6 หลายเดือนก่อน +1

    crazy guy...fantastic!