Sorted datatable in visual " table"

[rachnajn28]

I have a data table containing articecode podate netprice masternetprice 

I sorted this table on articlecode and podate by power query , its doing fine

Then i created calculated columns for previousnetprice and pricechange

When i see the table from query its correct

But when i drag the data in visual " table" sorting by podate within article code is not maintained 

1 articlecode can have multiple podates

Please suggest .

Thanks

[Anonymous]

Hi @rachnajn28 ,

Please have a try.

Sort a table by multiple columns in Power BI is to use the Sort By option in the ellipsis menu of the table visual. You can select Sort By -> Sort Columns and then choose the columns you want to sort by and their order. You can also change the sort direction from ascending to descending or vice versa.

Change how a chart is sorted in a report - Power BI | Microsoft Learn

How To Sort A Table Using Multiple Columns In Power BI (c-sharpcorner.com)

How to Get Your Question Answered Quickly 

If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

Best Regards
Community Support Team _ Rongtie

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[rachnajn28]

in visual and in power query table is showing data in perfect order, but when i create index  either in power query or DAX  - as i want indexing for articlecode and on MRINDate within Articlecode, index value is jumping.

articlecode  MRINDate        Indexcol     required

11-101-004  15 April 2022    2               1

11-101-004   21 April 2022     2              2

11-101-004   04 July 2022      6             3

                      13 August 2022     8         4

                       17 August 2022    5         5

                        08 October 2022  6

                         14 November     7

then till 13 it's fine 

                        07 April 2023      28     14

                        08 April 2023      15      15

rest is ok  for this Articlecode but whenever any Articlecode has more MRINdates its' jumping

whenever articlecode changes it'  resetting the value to 1, that's fine

[ChiragGarg2512]

Sort the table in table view the same way as done in power query. There is also the option to sort by column, so the choice can be made to sort on column of choosing.