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