Forum Discussion
Helper IIIConcatenate labels in matrix
Hello,
Is it possible to concatenate labels in the columns of a matrix ?
I have in columns the day of month and I want to show the month also because my month goes to july 1st to august 5.
In this exemple the header represents the day of month and the first row reprensents the sales. The problem is that 1st of july and 1st of august are in the same column (it's been summed)... What I want is the header like that : 1 2 3 ...30 31 1 2 3 5. So the idea would be to add a line above with name of month (that's why I talk about concatenate labels) but if there is another solution I am open.
Thank you very much for your help.
DM
Hi DM_BI ,
Do you want to get the output below?
If it is your case, you could create with date hierarchy (Month-Day )in matrix.
If you still need help, please share your data sample so that we could help further on it.
Best Regards,
Cherry
8 Replies
1) If you have date column in your data then you can format your date column "MMMM d" and use tin column header. If you do not have date column then create one using dax from month and day.
2) If you want format like "01-08" then create calculated column either in DAX or Power query and use that column in column header of matrix.
Date2 = FORMAT('Table'[Date],"dd-mm")If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
DM_BIAnonymous Thank you for your help. I thought about it but unfortunately my end user wants to see only the day of the month and not DD-MM or MMMM-D because it was in that format in excel and because if I put the month we cannot see everything in the table...
v-piga-msftResident Rockstar
Hi DM_BI ,
Do you want to get the output below?
If it is your case, you could create with date hierarchy (Month-Day )in matrix.
If you still need help, please share your data sample so that we could help further on it.
Best Regards,
Cherry
