Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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 ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Per your suggestion, I created a new table (Sort_LOB) with 2 columns:

LOB
Sort_LOB

Then I mapped the relationship between Employee table and this new table using the field 'LOB'.

For this solution, would I then put the LOB field and Sort_LOB fields (from new table) in the visualization, and then sort by Sort_LOB?
Because I did that, and LOB still wasn't sorted accordingly.

Thanks.

mjantune's avatar
mjantune
Regular Visitor
6 years ago
Anonymous wrote:

Per your suggestion, I created a new table (Sort_LOB) with 2 columns:

LOB
Sort_LOB

Then I mapped the relationship between Employee table and this new table using the field 'LOB'.

For this solution, would I then put the LOB field and Sort_LOB fields (from new table) in the visualization, and then sort by Sort_LOB?
Because I did that, and LOB still wasn't sorted accordingly.

Thanks.

Can you send an screenshot or something? Because that has always worked for me in the past. Also, in the new table you could sort the LOB field by the Sort_LOB field, and then just use the LOB field from the new table in the visualization, also check if its sort descending or sort ascending (just in case).