Forum Discussion
Custom tooltip for table with measures - sorting columns
Hi, Now92Jah
Your matrix data also seems to come from another table. Note that you need to sort the column fields in the matrix. Click on the column field of the matrix to sort by the sorting column. Instead of sorting the column fields summarized to another table.
To make it easier to understand, I created an Sample
Please refer to the attachment below for details. Hope this helps.
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community SupportHi, Now92Jah
Do you need to create a tooltip for a matrix and then sort the columns of the matrix?
If so, you can create a sorted table, use the RELATED function to add a sorting column to the main table after establishing a relationship with the main table, and finally sort the target column according to the sorting column.
You can check this thread for more details
sort months into chronological order
Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-angzheng-msft ,
Tried this solution - did not worked out. Maybe because it is used with the table which function is to be the headhers of a matrix, therefore it has only unique values?
Relation:Headers of the key table:
Supporting sorting table:
My final table, which needs to be sorted in my order (sorry for that, my model is to big to create sample data):
Any ideas, what can I do?
