COMPARE TWO PERIODS NATIVELY using Power BI // Beginners Guide to Power BI in 2023

Поділитися
Вставка
  • Опубліковано 30 вер 2024

КОМЕНТАРІ • 27

  • @arielherrera7738
    @arielherrera7738 13 днів тому

    Hi Fernan. This is amazing. Any chance you can share the file for this report?

  • @panivignesh3798
    @panivignesh3798 10 місяців тому +1

    Thank you for the video it's amazing to see what we can do in power bi. Well explained 👏

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

    Hi, is it possible to get sample files without being patron?

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

    Thank you for sharing this video. It was really helpful. I encountered a small hurdle when implementing previous period values greater than 1. In such cases, the start-end line only gave me 2 points instead of a straight line, but when the value was 1, I got the line. I'm not sure if this is a Power BI bug or if I missed something. Any advice you can provide would be greatly appreciated. Otherwise, I may have to stick to 1 year variance. Thank you.

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

      I'm getting two dots also. Did you find a resolution?

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

      @@tinaflemons263 change the x-axis to continuous instead of categorical and the line should appear. That is if you are using a date field on the x-axis

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

      @antonycatella5901 I got it to work. I ended up adding a calculated month column, so the month could be a date data type. Thank you

  • @PLara-tf4eg
    @PLara-tf4eg 5 місяців тому

    I have name cases on X axis and Value in Y axis. I need this approuch between every point or bar. How can something like this be done without dates. Jsut comparw two bars. And filter by different categories

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

    In my pbi i can't find these options dude, which version are you using..?

  • @normhamilton9602
    @normhamilton9602 8 місяців тому

    Thank for the video, I'm sure it something obvious but when I add the start end to Y axis I'm getting too dots over each of the time periods and not a line. What am I doing wrong?

  • @brightonalbert3237
    @brightonalbert3237 8 місяців тому

    if am interested in finding the total cumulative sales between the points i.e. (start Month - End Month) how would do that i.e. total sales between the points

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

    Very impressive. Thank you. I want to ask a question, what procedure should I follow to create a calendar with "Month" as a Date/Time data type as your own. My regards.

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

    You have watched a similar video from the Goodly channel and made yours 🤣🤣🤣

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

    Hi, I have been struggling to change the data source of my exile file in Power BI service and was wondering if you could please show me how to navigate through it.

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

    I just made something like this with small multiples and stacked an invisible column chart with my custom data labels on top for a sudo multi card effect with line graph. Great video 👍🏾

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

    Man I wanted to really understand this tricky dax behind this awesome trick. You are truly amazing ❤

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

    I have been waiting for this video since I saw Gustaw's post on Linkedin. Thanks a lot for sharing it!

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

    this is great...always love and appreciate your walk throughs.

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

    The sales expression in your dax is from which table?

  • @shanzeafreen8335
    @shanzeafreen8335 10 місяців тому

    i am facing a unique issue , on exactly following the same steps, instead of horizontal line, i am only getting pointers at selected month and previous month. Resulting the visual to look odd.

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

      I'm getting two dots also. Did you find a resolution?

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

    Hi. while watching a question popped in my head, would be gratefull for a little help. The sharp decrease at the end of the line chart is a pattern handling error where the "last date with value" is not the same as "last date in selection" thus the sales measure drops to 0.

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

      On the same note. Noob in PBi pls no flame

  • @SandipanSarkar-c8v
    @SandipanSarkar-c8v 8 місяців тому

    Finished watching

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

    super impressive!!

  • @jesusjohanncarrascoaguilar8449
    @jesusjohanncarrascoaguilar8449 10 місяців тому

    Buenazo !

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

    awesome