How to sort Months in descending order on a Power BI Matrix Table.

แชร์
ฝัง
  • เผยแพร่เมื่อ 15 พ.ย. 2024

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

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

    Thank you so much for providing easy steps to format the month in descending order. I had searched it for so much time on internet searching for the dax.

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

    Thank you so much. I searched online for so long to find this answer. Very easy to follow.

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

    Thank you very much for providing this solution

  • @irontrooperdsm13192
    @irontrooperdsm13192 2 หลายเดือนก่อน +1

    Sos un genio

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

    Is there a way to sort by the sales of each month? Like adding a sort function to each month column? Thank you.

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

    wwwooaaa thanks for this! you saved me

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

    did you create relationship between date table and data table?

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

    is there a way to do this on power bi online ?

  • @josephabuo6027
    @josephabuo6027 3 ปีที่แล้ว

    Advocates of laziness we are... Nice trick sir.

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

    Can you please video for dynamically changing column header while calculating current month sales and previous month sales. I have already calculated current month sales and previous month sales. I want the functionality that when I select the max "month and year" in filter, then the two column should occur on the power bi matrix .( Let's say , i have selected April 23-24 from filter then the two column should appear in power bi matrix. They should be April 23-24 for current month and year and March 23-24 for previous year. If i select March 23-24 from the filter, then two column should appear they should be march23-24 and Feb 23-24. Thanks in Advance. Please try to post the video sooner.

  • @nathanschneider1805
    @nathanschneider1805 5 หลายเดือนก่อน

    Is it just me, or does anyone else think it is absolute insanity that you have to go through this much work to sort in PowerBI? I am coming from Tableau where this was as easy as a drag to reorder

  • @damn68
    @damn68 2 ปีที่แล้ว

    Can you do one for years. So that 2022 will be first, and then desc order . I stead of month

    • @ForesightBI
      @ForesightBI  2 ปีที่แล้ว

      You can create a new column with year showing with negatives then use that to sort.

  • @mohammedhammadahmed2168
    @mohammedhammadahmed2168 3 ปีที่แล้ว

    Nice sir

  • @GPraxedes
    @GPraxedes 3 ปีที่แล้ว

    Thx

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

    th-cam.com/video/k5FMfvPmkv4/w-d-xo.html

  • @Turbo_PilotSky
    @Turbo_PilotSky 2 ปีที่แล้ว

    All good great hack thank you but the explanation is way to repetitive and verbose, the whole thing could be done in half a time , unless the public has below average comprehension rate