Forum Discussion
Sorting row or column values in a specific order
Hi, this is a 2-part question. Part #1: I followed a previously published solution: https://community.powerbi.com/t5/Desktop/Sorting-rows-and-columns-in-matrix-visual/m-p/723838#M349347 to try ...
hi Anonymous
You need to add two conditional column in edit queries as below:
Then use sort by column in power bi desktop the row and column.
https://radacad.com/sort-by-column-in-power-bi
Result:
and here is my sample pbix file, please try it.
Regards,
Lin
Thanks, but I have one question though.
LOB is from one table, and 'Type' is from a different table.
That would mean I can't do conditional column, right?
Or, if I can, how do I do that?
Thank you!