Forum Discussion

jjustjjo's avatar
jjustjjo
Helper II
2 months ago
Solved

Tableau Sort Trick in Power BI

I have a Tableau report I'm trying to reproduce in Power BI.  I have everything except the Sort Order. There is a Parameter:  The Calculated field which uses it:  And the trick is the ...
Need Help
  • Rupa01's avatar
    Rupa01
    2 months ago

    jjustjjo Change datatype of "SortBy" Measure to Whole Number. Apply Visual sort using "SortBy" Measure Ascending, but the measure will override this by dynamic sorting logic.

     

    Also, note that you are creating the SiteNameSort, SubjectIDSort and VisitDateSort are calculated columns with data type whole number.

     

    Check below Sample snapshots for reference - 

    Visit Date is sorting desc order - 

    Subject ID is sorting asc order - 

    Default (Site Name) is sorting asc order - 

     

    To Unhide the column - Remove the hidden column from the visual and re-add if you are unable to resize the width to make it visible

     

    💡 Helpful? Give a Kudos 👍 — keep the community growing
    ✅ Solved your issue? Mark as Solution ✔️ — help others find it faster

    Best regards,
    Rupasree Achari | BI & Fabric Analytics Engineer
Anonymous's avatar
Anonymous
Not applicable
2 months ago

Power BI has 2 different functions that might be applicable here.  Firstly you can define a sort order column for any column in your data table.  So your Text values could be sorted by another field that is a number.

 

Secondly, sort order of a table can be changed by the user clicking the header of the table itself. You don't need a drop down menu for a user to change the order of a table.