Concatenate labels in matrix

[DM_BI]

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

[Anonymous]

@DM_BI 

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_BI]

@Anonymous 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-msft · Accepted solution]

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

[DM_BI]

Hi Cherry,

Thank you for your answer. I have tried but sorting by number of month doesn't work in my DimDate table because there are several lines (not unique values). Do I really have to create another table with uniques months to be able to sort the months? I already have so many tables in my model.

Thank you

DM

[mussaenda]

You can create a column for the numbers of the month then you can use this to sort your month.

[DM_BI]

Thanks it works !!