SortBy Column ... Driving me Crackers!

[iand66]

Sometimes you just need a helping hand from someone else before you go off and do something stupid ... like buy Tableau!

I have two user defined tables 'Metrics' & 'ShowAs' with SortBy Column set to 'Index' (integer / whole number in both cases)

On report view 'ShowAs' slicer sorts in index order (i.e. non-alpha which is what I want) ... can't get 'Metric' slicer other than ascending or descending alpha. Messed with all possible combinations of Sort Axis. Both slicers work i.e. data on card updates as expected {Index of Metric shows as Text on screenshot - changed it to INT & no difference}. Saved & reloaded, Ctrl-Alt-Del, shutdown, stooded on one leg with my finger in left ear, and then right ear ... and all to no avail 😞

Worked OK last time I did it (about 12 months ago)

PBI desktop version is 2.110.1161.0 (22.10) (x64)

[Mikelytics · Accepted solution]

Hi @iand66 

Please use the sort by column feature:

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[Mikelytics]

HI @iand66 

Did it solve your challenge?

If yes please mark my post as solution.

Best regards

Michael

[iand66]

Hi Mike, thank your for the response. As mentioned in the original post "I have two user defined tables 'Metrics' & 'ShowAs' with SortBy Column set to 'Index'" ... so have already been down all the obvious routes. Fortunately, Rico Zhou has already accepted your idea as a solution on my behalf. Now all I have to do is figure out how to get PBI to do what I want, in the way that it used to (see above screenshot)