Table Visual Sorting

[rogzon]

Hi!

Do anyone know if Microsoft will release a simple table visual with sorting disabled option and "hide column" option?

Right now the visual sorts by the first column alphabetically and on top of that it handles the three extra letters of the swedish alphabet wrong.

What I need is to present a table with data sorted in the way I do in my source (and yes databases generally handles the swedish characters quite good).

/R

[johncolley]

Hi Roger, 

Once you have selected the column to include your table you can select 'sort by column' to sort this column by the 'sorting column' without having to show it in the table.

Regards,

John

[rogzon]

Hi John,

So the sorting you mention is done in the table view?

Unfortunately the table visual still sorts by the first column added to it, it ignores the sorting in the table view.

If the "sorting column" isn't present in the table visual I am not able to "sort by" it in the visual.

Was that what you meant or am I missing something?

Regards,

/Roger

[johncolley]

Hi Roger,

It can be done in both the report or data views. In my screenshot the left table would be the one you are trying to produce. The status column is not the first column. But the table is sorted by the sort order you can see in the right hand table even though it's not present in the first table.

[rogzon]

Hi John!

I can't reproduce your images above, how did you do that?

Did you make any changes to the table visual?

The moment I add a column to my visual it sorts immediately...

/Roger

[johncolley · Accepted solution]

No changes to the table visual.

Steps i take are:

1. Select field to sort from field list.

2. Under Column Tools in the header select 'Sort by Column'

3. Select the 'sort order' column and the table should update to reflect the ordering. 

4. If you add additional columns and the ordering changes, just reclick the column header you want to sort on or follow the image PhilipTracey provided.

[rogzon]

Ahh, this drives me crazy... By not using the column tool but only click the column and use "Sort Ascending" doesnt give you the same result as choosing "Sort by" under column tools.

Column tools makes the sorting stick, great job thanks a lot to all involved!

[PhilipTreacy]

Hi @rogzon 

You can choose what column to sort a table by 

What are your Global Regional Settings?  These determine how strings are compared/sorted

File -> Options and Settings -> Options 

Regards

Phil

[rogzon]

Hi! @PhilipTreacy 

The regional settings were unfortunately correct (Swedish), it would have been a neat solution thanks.

When it comes to sorting I would need the table visual not to sort at all, the correct sorting is done in my source so if there is a table type visual that does not sort I would be happy.

A possible workaround would be to create a "sorting column" but the data in that column is of no interest to the users and I am unable to hide it in the visual.

So either a table visual with the ability to disable sorting or a table visual where columns could be hidden would do the trick for me, any suggestions?

Reagrds,

/Roger

[Anonymous]

Hi @rogzon ，

You can add this calculated column (created as an workaround) to the visual, select the corresponding visual, go to the Format pane to toggle off the "Word wrap" option. Then try to resize the column to the smallest size in the visual until you can't see... The calculated column will be hidden, and you can sort by it on the visual...

In addition, you can refer the following links to implement it.

Power BI – Sorting data by a column not shown in visual

Hide Columns in Power BI | Power BI Tricks & Tutorials

Power BI Sort - Hiding the sort Column

Best Regards