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
Resident RockstarHi 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
Helper IIIv-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
Community Champion
You can create a column for the numbers of the month then you can use this to sort your month.
