Unable to sort data by daily period in Chart Visual mode where source from SSAS Tabular

[octoni]

Hi,

Does anyone know how to sort data in Chart visual mode where the data source feed from SSAS Tabular ? 

So there is a dimension period in SSAS where the day column is already sorted via SSAS Modeling. 

When I display the data in Power BI Desktop of regular table layout, the sorting is working, but when I try to change in Chart visual mode, it's not.

Really appreciate for any thought. Thanks

Cheers,

Octoni

[Anonymous]

@octoni,

How do you connect to SSAS tabular , using import or connect live mode? Could you please post a screenshot of your chart and table visuals?

Regards,
Lydia

[octoni]

Hi,

I use live mode. 

Here is the screen shot of basic table layout where the period sequence is automatically with correct order

and here is the screen capture of chart layout, where the daily period sequence order is not correct.

[Anonymous]

@octoni，

What is the data type of the Day field, Text or Date?

Regards,
Lydia

[octoni]

The data type of Day field is Text, because we need to maintain the standard format. But in SSAS tabular model, the columns is already sorted by another column, called Date_Key whic is number data type.

Regards,  Octoni

[Anonymous]

@octoni,

Do you use December update of Power BI Desktop and could you please make sure that the column is sorted correctly in SSAS data model? 

I test the scenario as yours, sorting works well in my environment, please review my screenshot.


Regards,
Lydia

[octoni]

Hi Lydia

I've tried to upgrade the Power BI Desktop to the version fo Decembe-2017. Yet it still didn't order the row data automatically by date key in Chart View. 

[Anonymous]

@octoni,

I would recommend you open a support ticket on the support.powerbi.com site.


Regards,
Lydia

[octoni]

Hi Lydia,

What version of Power BI Desktop you are using ?

regards, OCtoni

[Anonymous · Accepted solution]

@octoni,

I am using the same version of Power BI Desktop as yours.

Regards,
Lydia