Visual table with two sort levels

[Syndicate_Admin]

Hola a tod@s,

Could you tell me if there's a way for a PowerBi user to put two sorts into a table-type visual.

For example, I have a visual of the table type with 3 columns: price, quantity, and name. The user wants to apply a first-level sorting by price and a second-level sorting by quantity. The table has a thousand records.

The user is the final user of the report, so they will not have access to developer mode (they cannot use DAX and objects are blocked from modifications)

Thank you in advance

Pablo

[v-priyankata]

Hi @Syndicate_Admin 
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please Accept it as a solution and give it a 'Kudos' so others can find it easily.
Thank you.

[v-priyankata]

Hi @Syndicate_Admin 
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. If response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[v-priyankata]

Hi @Syndicate_Admin 

We are grateful for your participation in the Microsoft Fabric Community forum.

Thanks @lbendlin for the promt response, @Syndicate_Admin the solution suggested by @lbendlin was correct, can you please accept it as a solution, it will help to other members.

Thanks.

[lbendlin]

Sort multiple columns by using SHIFT-Click

[Syndicate_Admin]

Perfect, I was able to make it work, thank you. Can you tell me if there are any keyboard shortcuts for visual objects of the Matrix type? with a simple table I can do it, but when I try to do it in an object of type Array it doesn't allow me to do it.

[lbendlin]

That technique is only applicable to table visuals. For other visuals use "sort a column by another column".

[Syndicate_Admin]

Can the user do this from the compiled report? (If so, could you please explain how?)

Thank you

[lbendlin]

No, that is something the developer needs to do.

[Syndicate_Admin]

Hi, thanks for the reply, but for some reason this doesn't work in my table:

In the example you can see that sort by first level Order Number and by second level PAX, but the result shows the PAX column completely out of order. Can you tell me if you have a particular version of PoweBi? Do I need to configure the object in any specific way?

Best regards

Pablo