Forum Discussion

ilcaa72's avatar
ilcaa72
Helper IV
8 years ago
Solved

Matrix with proper date column headings

i had month, year data as string, i fixed it and converted to DATE, It now appears as May 01, 2018.   i am using the Matrix but hate the column Header. Changing it to Month only shows month, not ye...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    Hi ilcaa72

    You could consider two ways

    1.Change the format of "date" column to "mmmm yyyy".

    2.  Add "date" column to "column" field of the matrix, then set it as "date hierachy", then delete "Day" and "Quarter", click on the "double arrow" which is called "at the lowest level".

     

    Best Regards

    Maggie

Orstenpowers's avatar
Orstenpowers
Post Patron
2 years ago

v-juanli-msft 

I found your solution above, which is also working fine with me, but I would need two adjustments that I don't get managed.

1. How to sort year/ month descending, so to have Feb 2024, Jan 2024, Dec 2023 from left to right etc.?

2. As values, I inserted the net amount per month. I would like to insert another value, the relative change from one month to the other. The measure itself is working, but how can I arrange that this percentage value is directly below the relevant net amount?

 

Best regards
OrstenPowers