cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
octoni Frequent Visitor
Frequent Visitor

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

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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

@octoni,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
9 REPLIES 9
Moderator v-yuezhe-msft
Moderator

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

@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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
octoni Frequent Visitor
Frequent Visitor

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

 

Hi,

 

I use live mode. 

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

 

Capture1.PNG

 

 

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

 

Capture2.PNG

Moderator v-yuezhe-msft
Moderator

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

@octoni

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
octoni Frequent Visitor
Frequent Visitor

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

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

Moderator v-yuezhe-msft
Moderator

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

@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.
1.JPG

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
octoni Frequent Visitor
Frequent Visitor

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

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. 

 

Capture_Power_BI_Dec_2017~.PNGCapture_Power_BI_Dec_2017.PNGCapture_Power_BI_Dec_2017~2.png

Moderator v-yuezhe-msft
Moderator

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

@octoni,

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


Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
octoni Frequent Visitor
Frequent Visitor

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

 

Hi Lydia,

 

What version of Power BI Desktop you are using ?

 

regards, OCtoni

 

 

Moderator v-yuezhe-msft
Moderator

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

@octoni,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.