Forum Discussion
Sorting Table with 2 Datasets
Hi V-lian-msft,
Thank you so much for replying on my issue. I think you get the problem correctly but the post you refer to is for sorting on multiple columns inside the same dataset/table.
I have Dataset1 with some Employee-data and Dataset2 with som Sales-data and a Date-column. But, Dataset2 do not contain the Employee-number so there is a relationship between theese 2 datasets.
Into a Table visual I drag the Dataset1.EmployeeID, Dataset2.Date and Dataset2.SalesAmount, and would like that the sorting of the rows in this Table visual is done first on Dataset1.EmployeeID and then on Dataset2.Date, but the sorting seems to be random. I have tried doing the sorting in the actual sql getting the data for each Dataset and also in Power Query. As long as I use 2 different Table visuals, one for each table the sorting is ok, but when I combine these into one Table visual it is messed up.
Hi Tempus-Tommy ,
I understand your intention,you can refer to the post below
https://community.powerbi.com/t5/Desktop/Sorting-by-multiple-columns/m-p/535690
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks, but this is pretty much the same scenario as before since all the columns is in the same table/dataset.
Hi Tempus-Tommy ,
What is the relationship between the two tables? What is the direction of "cross filter direction"?
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
Cross Filter Direction is "Simple".
If I delete the Table Visual and add a new one and then drag the fields to to visual in the same order I want the sort to happen, then it seems to be ok. But not possible to change afterwards.