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

Re. Part #1

 

I changed the Sort_LOB calculated column to the SWITCH dax, then I selected LOB and sorted by Sort_LOB, and encountered and error message - screenshot attached.

mjantune's avatar
mjantune
Regular Visitor
6 years ago

is [Lob] a measure or a Column?

You could also create a new table (Sort_Lob) to do the sorting.

 

 

 

 

LOBSort_LOB
Accounts1
Esc Accounts2
Billing3
Esc billing4
Tech5
Esc Tech & hardware6

 

Then you relate this table to the Employee_Team table you want to sort, and use this Sort_Lob table in the report.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    [LOB] is a field/column from a SQL table.

  • 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).