Forum Discussion
Sorting Text in Matrix table visual
Hi New_be ,
If you want the latest date to be at the top, you should descend first, then add an index.
You can refer the following steps.
1. We need to create a unique Year&Month table. And sort the column.
2. Then create an index column.
3. Create an one-to-many relationship with Actual table.
4. At last, in the matrix table visual, put the Table[Year&Month] to Column and sort it by Index.
If it doesn’t meet your requirement, could you please provide a mockup sample based on fake data and describe the relations between tables?
It will be helpful if you can show us the exact expected result based on the tables.
Please upload your files to OneDrive For Business and share the link here. Please don't contain any Confidential Information or Real data in your reply.
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
BTW, pbix as attached.
Hi,
- Create a year & month column in the Calendar table as well
- Create a relationship from the Year and Month column in the Calendar Table to the Year and Month column in the Year Month sorted table
- Write this calculated column formula in the Calendar table to bring over the Index column from the Year Month sorted table. Month index = related('Year Month sorted'[Inde])
- Click on any one cell in the Year & month column of the Calendar table (the one you create in step 1 above) and use the "Sort by" feature to sort the new column by the Month index column (the one you create in step 3 above)
- Remove the relationship between the Actual and Year and Month sorted table
- To your visual, drag Year and Month from the Calendar Table.
Why do you have a Many to Many relationship between the Calendar and Actual tables?
Great answer! thanks for your time. Really appreciate that