Forum Discussion
ilcaa72
Helper IV
Helper IVMatrix 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...
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
v-juanli-msft
Community Support
Community SupportHi 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