sort definition lost

[Anonymous]

On feb 12 i updated PBI desktop to februari 2018 release and republished one of our sales datasets. It seems that at that time the definitions of sort by other column was lost.

[v-qiuyu-msft]

Hi @Anonymous,

Do you mean set a visual sort by a column? 

Based on my test in Power BI desktop version 2.55.5010.641 64-bit (February 2018), create a table visual and set as sort by OrderYear column, after publishing to Power BI service, the table visual still be sorted by the OrderYear column. 

Please make sure you are running the same desktop version as ours. If issue persists, would you please share a sample file for us to test on our side?

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi, the steps to reproduce are:

1. use 2.54.4970.961 64-bit januari 2018, create new report

2. get SQL table (maybe other datasource type will work as well) with these values: 

    Name   MySortOrder

    COG     2

    OTH      3

    PBI        1

3. load the table to the model (leave query editor)

4. select field table.Name, select Modeling>Sort by Column, select field MySortOrder.

5. Use the field Name in a Table visual, don't do additional sorting in the visual, should look like this:

    Name

    PBI
    COG
    OTH

5. save the report, close pbi

6. install 2.55.5010.521 64-bit february 2018, open report

7. Refresh. Sortorder is lost:

    Name
    COG
    OTH

    PBI
    

The issue seems to be solved in the newer 2.55.5010.621 by the way.