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

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

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

  • @idontknowexcel
    @idontknowexcel Год назад +3

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

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

  • @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

  • @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 ))))

  • @musariololade2204
    @musariololade2204 8 месяцев назад +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.

  • @imstillbreathing1
    @imstillbreathing1 Год назад +1

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

    • @dganalysis
      @dganalysis  Год назад

      Thanks, working on some more...

  • @emilyamalkin4367
    @emilyamalkin4367 Год назад +1

    Great content! Liked and subscribed 👍🏻

    • @dganalysis
      @dganalysis  Год назад

      Thank you, appreciate the support. Glad you liked it

  • @albedoguardian875
    @albedoguardian875 7 месяцев назад +1

    Underrated Gem 💎

    • @dganalysis
      @dganalysis  7 месяцев назад

      Thanks, appreciate it 👍

  • @jaidevsolanki2259
    @jaidevsolanki2259 Год назад +1

    Very well explained. Thanks

    • @dganalysis
      @dganalysis  Год назад

      Thank you Jaidev, appreciate the feedback

  • @mindaugasseka
    @mindaugasseka Год назад +1

    superb charts! Thank you!

  • @abdulmalekalsaati4856
    @abdulmalekalsaati4856 Год назад

    Very creative and helpful, thank you for sharing.

  • @woodleygeneus1537
    @woodleygeneus1537 Год назад +1

    Thank you for sharing this very informative video.

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

  • @ragragrec1
    @ragragrec1 Год назад +1

    Killer stuff as always. thankyou

  • @tinaflemons263
    @tinaflemons263 Год назад +1

    Love your content

    • @dganalysis
      @dganalysis  Год назад

      Thank you Tina, appreciate it 🙌

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

  • @JoséAlmeida-v1g
    @JoséAlmeida-v1g Месяц назад +1

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

    • @dganalysis
      @dganalysis  Месяц назад

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

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

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

    May I know the color scheme for your pbi?

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

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

  • @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

  • @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!

  • @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 9 месяцев назад

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

  • @petertrnka459
    @petertrnka459 7 месяцев назад +1

    crazy guy...fantastic!