Forum Discussion
Table Visual Sorting
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.
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
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