Sort in 2 ways at once one visual single dataset

Source Name and Status are two different columns, therefore you can sort them by the values of another column

For the Status if you do not have already a suitable table, you can create it (insert data in Power BI Desktop)

Status                        Order

Past Due                      1
Due in < 30 days         2
Open                           3

Connect this table 1 to many to the Fact table, bring the Order in the Fact table trhough a calculated column using the RELATED function and sort Status via the values of Order

If this helped, please consider giving kudos and mark as a solution

me in replies or I'll lose your thread

consider voting this Power BI idea

Francesco Bergamaschi

MBA, M.Eng, M.Econ, Professor of BI

Hi E_K_ ,

You've got a classic Power BI sorting challenge here. Both responses you received are correct, but let me give you the complete solution.

FBergamaschi 's approach is the best practice method:

Step 1: Create a Status Sort Table Go to Home → Enter Data and create:

Status               Sort Order
Past Due             1
Due in < 30 days     2  
Open                 3

Step 2: Create Relationship

• Model view → Drag from Status Sort Table[Status] to your main table[Status]
• Set as 1:Many relationship

Step 3: Sort the Status Column

• Data view → Select Status column
• Column tools → Sort by Column → Select "Sort Order"

Step 4: For Source Name (if you need custom sorting) Create another table:

Source Name          Sort Order
RCI                  1
Audit Issue          2  
RCI Action           3
Audit Action         4
Op Event Action      5

Follow the same relationship and sorting steps.

Alternative: Query Editor Method If you prefer the conditional column approach:

• Transform Data → Add Column → Conditional Column
• Create rules for Status sorting (Past Due = 1, etc.)
• Sort Status by this new column

Both methods work, but the separate table approach is cleaner for maintenance and reusability across multiple reports.

If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.

This response was assisted by AI for translation and formatting purposes.

Hi E_K_,

Thanks for reaching out to the Microsoft fabric community forum.

You qre right that Power BI visuals like the matrix don't let you directly sort two different columns by two different fields within the same table. However, as FBergamaschi and others suggested the workaround to create sort helper tables and then link them to your fact table. Kindly go through their responses and check if your issue can be resolved.

I would also take a moment to thank burakkaragoz, danextian and FBergamaschi`, for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.

If I misunderstand your needs or you still have problems on it, please feel free to let us know.  

Best Regards,
Hammad.