Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
I made a matrix in which the column y is divided by proceeds and total costs. So, the distinction is made by the matrix. Now I think it is sorting on the alphabet. However, I'd like to show first total costs and then proceeds. I don't know how to sort this because these values are actually one column in the data.
Thank you in advance.
Regards,
Tom
Solved! Go to Solution.
Hi @Bipin-Lala
Thank you for your answer.
I eventually solved it on a different way:
I made a conditional column, with total costs = 1, proceeds = 2 (called it ranks).
Then I made this ranks column a number type.
Then I sorted the table on the basis of the ranks column. This causes that the initally column also got sorted in the right way.
When I tried again in the matrix, I got the sequence I wanted.
Regards,
Tom
Hi @Bipin-Lala
Thank you for your answer.
I eventually solved it on a different way:
I made a conditional column, with total costs = 1, proceeds = 2 (called it ranks).
Then I made this ranks column a number type.
Then I sorted the table on the basis of the ranks column. This causes that the initally column also got sorted in the right way.
When I tried again in the matrix, I got the sequence I wanted.
Regards,
Tom
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
89 | |
86 | |
75 | |
69 | |
68 |
User | Count |
---|---|
220 | |
128 | |
117 | |
82 | |
77 |