cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vishnuprashanth
Helper III
Helper III

Sorting the Column Series by date order in Line and Stacked Column chart

I have created a Line and stacked column chart for each week. 
 

Since the values are grouped by date in the week, the values are not shown in a proper order of date.

 

How can I sort it, so that, it is displayed in the increasing order of date? 

Attached screenshot with an explanation. How can I sort the column series with respect to date? 

 

need to sort the column series/legend value in the increasing order of dateneed to sort the column series/legend value in the increasing order of date

4 REPLIES 4
v-yuezhe-msft
Microsoft
Microsoft

@vishnuprashanth,

I am not clear about your requirement. In the specific day 1/14/2018, how would you sort the column values by different dates orders? 

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.

Hi @v-yuezhe-msft

It is not for a specific date.

It is for a week. 1/14/2018 indicates the start of the week and 56 indicates the week number from my calendar. 
I want to sort my stacked chart in the increasing order of dates of that week, from 1/15/2018 to 1/20/2018.

Hope it is clear for you now and you could suggest me a solution for this problem.

Regards,
Vishnu

@vishnuprashanth,

The columns in  the chart display different vaues of legend categories in specific week(56), and the Y scale is generated based on these numerical values, I don't think that yuo can sort these values in date order and dispaly the order in Y scale.

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.

Thanks, @v-yuezhe-msft.  Even I was thinking that it would not be possible to do this. I can sort it in a specific order by giving the categories a ranking value, but not sort it with respect to dates. 

Thanks for the clarification Lydia. 

Regards,
Vishnu

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors
Top Kudoed Authors