Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@octoni,
I am using the same version of Power BI Desktop as yours.
Regards,
Lydia
@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
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.
@octoni,
What is the data type of the Day field, Text or Date?
Regards,
Lydia
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
@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
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.
@octoni,
I would recommend you open a support ticket on the support.powerbi.com site.
Regards,
Lydia
Hi Lydia,
What version of Power BI Desktop you are using ?
regards, OCtoni
@octoni,
I am using the same version of Power BI Desktop as yours.
Regards,
Lydia
User | Count |
---|---|
88 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |