Visual table with two sort levels

Question

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 advancePablo

lbendlin · Answer

Sort multiple columns by using SHIFT-Click
&nbsp;

&nbsp;

syndicate_admin · Answer

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

syndicate_admin · Answer

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 · Answer

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

syndicate_admin · Answer

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

Forum Discussion

Visual table with two sort levels

9 Replies

Related content

KPI level matrix table

export from visual table

Table visual error

Matrix Visual Hierarchy Level Problem

Table Visual not Matching Calculated Visual