Sort Date axis (Year, Month, Day) on app.powerbi.com

[nrk001]

Hi Team, I'm directly pushing the data from streaming job and creating a report on app.powerbi.com

Would like to know how to sort hierarchies in a correct way? From the timestamp, I've extracted Year, Month & Day columns.

I'm getting the below output,

2017 Feb 1,

2017 Jan 29,

2017 Jan 30,

2017 Jan 31

Correct sort output,

2017 Feb 1,

2017 Jan 31,

2017 Jan 30,

2017 Jan 29

Please assist!

Best Regards

[v-yuezhe-msft]

Hi @nrk001,

In Power BI Service, I am afraid that you are not able to achieve the above requirement.

In Power BI Desktop, you are able to add another column defining orders for the date field  to your dataset, then use the Data Tools Modeling tab to sort date column by the newly added column. For more details, please review this blog.

Thanks,
Lydia Zhang

[nrk001]

Thanks Zhang for the response!

Challenge is that the streaming dataset cannot be connected to Power BI desktop to create a custom sort column.

Is there a workaround which can be implemented?

Best Regards

[v-yuezhe-msft]

Hi @nrk001,

I am afraid that there is no workaround in Power BI Service side.

Thanks,
Lydia Zhang

[nrk001 · Accepted solution]

Thanks for the response! What I've done is I've extracted Month (as varchar), Day (as Int) and Hour (as Int) such that I can sort on continuous variables and still have the desired sort order and it worked.

Best Regards