Forum Discussion

gmat's avatar
gmat
Icon for Helper I rankHelper I
2 years ago
Solved

Formatting Year Over Month in Matrix

I'm currently working on creating a reporting packet in Power BI, and I've encountered a formatting challenge that I hope someone can help me with.   I have set up a matrix with a hierarchy where t...
Need Help
  • danextian's avatar
    danextian
    2 years ago

    Hi gmat ,

    You can sort of achieve this by adding a calcualted column of year with an extra space/s after the year based on the month number but take note that each year in the calculated column will have its owns subtotal if enabled each new being a distinct value.  Please see attached pbix for your reference

     

danextian's avatar
danextian
Icon for Super User rankSuper User
2 years ago

Hi gmat ,

You can sort of achieve this by adding a calcualted column of year with an extra space/s after the year based on the month number but take note that each year in the calculated column will have its owns subtotal if enabled each new being a distinct value.  Please see attached pbix for your reference

 

  • gmat's avatar
    gmat
    Icon for Helper I rankHelper I
    2 years ago

    This is very helpful. I imported your calendar table.. Do you know how to sort these so it is from oldest to newest.. April 2023 - March 2024

     

    • danextian's avatar
      danextian
      Icon for Super User rankSuper User
      2 years ago

      I believe there is a YYYYMM column in there which can be used as a sort by column.