Forum Discussion
Helper IIIConcatenate labels in matrix
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
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.
Helper IIIAnonymous 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
- DM_BI
v-piga-msft hi, this is exactly what I was trying to do! It finally works thank you. Last question/problem that I have : I can only sort by what I have in my rows, but I would like to sort by month (what I have in columns). Do you know if I can do that ? Because for the moment August comes before July.
Thank you very much for your time.
DM
- v-piga-msft
Hi DM_BI ,
Sorry for the delay.
We could use the feature sort by column to achieve your desired sort.
Firstly, you need to create an Index column based on the order.
Then sort the month column by index column under data view like below.
Hope this can help you.
Best Regards,
Cherry