Sorting in table

[AndreaSo]

Hi, 

I have problems with sorting in a table visual. I have a column with 5 specific values and I created an index column according to wich  I would like to sort it.

I created an example:

Values + index column

compain start	index
start in 5 months	1
start in 4 months	2
start in 3 months	3
start in 2 months	4
start in 1 month	5

Current data:

Project	Current values	Index
1	start in 5 months	1
2	start in 3 months	3
3	start in 4 months	2
4	start in 2 months	4
5	start in 5 months	1
6	start in 3 months	3
7	start in 1 month	5
8	start in 2 months	4

Expected sorting in table visual: (please mind that I dont want to show the index column in the visual)

Expected result in table visual

start in 5 months

start in 5 months

start in 4 months

start in 3 months

start in 3 months

start in 2 months

start in 2 months

start in 1 month

Please let me know if I was not clear enough. Thank you a lot for help.

[Adamboer]

To sort your table visual according to the index column you created, you can follow these steps:

1. Select the table visual that you want to sort.

2. In the Visualizations pane, go to the "Fields" section and find the column that you want to sort by (in this case, the index column).

3. Click on the column and drag it to the "Values" field well of the table visual.

4. Click on the column header in the table visual to sort by that column. You should see the data sorted according to the values in the index column.

5. If you don't want to show the index column in the visual, you can remove it from the "Values" field well by clicking on the "x" next to the column name.

After completing these steps, your table visual should be sorted according to the values in the index column, as expected.

[Arul]

@AndreaSo ,

You have to use sort by column option to sort your current values column based on index,

Thanks,

Arul

[AndreaSo]

Hi Arul

I tried this but unfortunately once I add it into the visual table, and sort based on "Currect values", it order is not correct.

[ahmedoye]

If you have done as @Arul suggested, and the sorting is not reflecting yet, go to your Table Visual and click on the header of the column inside the visual. Yoy may need to click twice to change the sorting between Ascending and Descending as you wish.