How to show OVERLAPPING BAR CHARTS in Power BI // Show and Compare Variance

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

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

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

    Nicely done! That's elegant.

  • @sadiqabkr
    @sadiqabkr Год назад +2

    Excellent work. Very impressive. Thank you

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

    What a great idea! Thank you so much!

  • @PratyashaSingh-v6y
    @PratyashaSingh-v6y 4 месяца назад +1

    Thank you! but when I open the overlaying chart in focus mode after grouping them, only one of them appears. Is there a way to have both the chart view together in focus mode?

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

    I hope they could add this a native functionality since it would really be helpful in comparing data. In scenarios like this, I miss working in Excel. 😅

    • @SM23Studio
      @SM23Studio 10 месяцев назад +2

      it's available in 2024 february update - so it's finally natively supported

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

      I overlooked the blog update. 😅

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

      @@kuuuyajim actually it was not mentioned in the blog.
      I only saw Gustaw Dudek’s linkedin post about this feature.
      I immediately used it in my actual project… so helpfuk

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

    Great video! Is it somehow possibile to show the data labels for previous and current month? Like not only the variance, but also the value representing the height of the bars.

  • @Patrick-d7t
    @Patrick-d7t 11 месяцев назад

    I am a beginner and my chart isn't working as expected. When I select a specific month (for example, November 1997), it only displays the sales for that month and not the previous month's sales. However, when I remove the date filter, it shows both - the current and previous month's sales. Could you please explain why the calculation for the previous month is affected by the date filter?

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

    How do i add a legend to make it clear that they grey is a previous week and the current is blue ?

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

    Is there any way to add label to show which color is current year sales vs previous year sales

  • @marlonetzel6450
    @marlonetzel6450 6 месяцев назад

    nice video. But it very difficult to this with a multi color backround. Any tips on that?

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

    how we would calculate max axis if our chart would have as x axis dates and y axis one with monthly sales and the other last year same month ?

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

    is it possible to show the data labels in bar charts, like can we show percentage on labels as well?

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

    I am facing
    The syntax for 'RETURN' is incorrect. (DAX(DIVIDE(Risk_Assessment[Risk score current],Risk_Assessment[Prv. risk score]) - 1RETURN)). problem while creating a upward or downward trend

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

    well done Fernan!

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

    Thank you Fernan

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

    Amazing, Thanks so much

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

    excellent video and will try to implement

  • @balajis2269
    @balajis2269 4 месяца назад

    Excellent ideas, thanks for posting, i am looking the same to present..👌👍

  • @deryansyah
    @deryansyah 4 месяца назад

    how about creating this chart type based on last year same month?

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

    super! i'm looking for overlap bar

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

    How does this work in focus mode ?

  • @nikhilsharma-yf3qm
    @nikhilsharma-yf3qm Год назад

    What if you focus or make the chart full screen, will it be the same visual??

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

      just one probably

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

    nice example. Thanks

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

    How do I export it as one?

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

    Warning: You have to be overly extremely careful when editing this type of overlapped charts. A single difference in font type or font size or a single different setting in the column charts can make the values of the "invisible axis chart" differ from the axis you see.

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

    Great

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

    This is really cool, however legends are wenr off. What is the way to keep the legend on for current amd last year data

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

    How to solve Data Table showing just 1000 rows

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

    🎉

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

    Outdated, i can only put 1 y axis data. WTF Microsoft?!?