topic Sorted datatable in visual " table" in DAX Commands and Tips

Sorted datatable in visual " table"

rachnajn28 — Thu, 21 Sep 2023 04:39:06 GMT

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

Re: Sorted datatable in visual " table"

ChiragGarg2512 — Thu, 21 Sep 2023 10:57:12 GMT

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.

Re: Sorted datatable in visual " table"

Anonymous — Mon, 25 Sep 2023 02:46:43 GMT

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.

Re: Sorted datatable in visual " table"

rachnajn28 — Mon, 25 Sep 2023 03:58:46 GMT

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