power bi table visual not showing result same as power query editor table

[fab196]

Hi everyone,

1)result i wanted and i got using power query listed below:

id	add1	add2	custom1	custom2	index
11	12	12	24	24	1
11	11	22	33	57	2
26	10	10	20	20	1
26	52	10	62	82	2
26	53	10	63	145	3

2)after fetching result to the power bi table visual chart the result appearing as of below mentioned:

id	add1	add2	custom1	custom2	index
11	11	22	33	57	2
11	12	12	24	24	1
26	53	10	63	145	3
26	10	10	20	20	1
26	52	10	62	82	2

i want to show the same result in power bi table visual chart as of i got in power query editor..(1)

how to i do this using dax .my data i  is so huge so i just only pasted few of all data.

please help ,

thanks in advance

regards,

fab

@v-kelly-msft please help

[V-pazhen-msft · Accepted solution]

@fab196 
This is a sorting question, the easiest way is:

1. Left click id column to sort by the id in ascending order

2. then hold on "Shift" left click index column to set second sort, also make it to ascending.

Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.

[Anonymous]

One way without using dax is create one index column in Power Query in your data. Just put this column in your table visual, you will get desire result.