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

time series

Started using the newest version of desktop BI.  Have noticed that when you are trying to build any visual with a time series as the X-Axis, the data is forcing itself to sort descending without any regard for the X-axis.  E.G. X-axis is Year then week.  Data is sales data over those week/year combinations.  Should trend out.  However, it puts that sales data in descending order and reorders the x-axis labels accordingly.  Any help would be greatly appreciated.

2 REPLIES 2
tabraunlich Frequent Visitor
Frequent Visitor

Time Series Charts not holding X-Axis values

Just downloaded the newest version of Desktop (2.57.5068.501 64-bit).  However, when I now try and creat any type of chart, where the x-axis is a time measure, the data in the chart sorts itself descending totally disregarding the time values.  E.G.  X-Axis is a week ending date for all of 2017 and the data is sales dollars.  Should (and has) trend itself out Jan-Dec.  Does not.  Automatically sorts itselfs by the largest sales week to the smallest sales week and reorders the dates on the x-axis.  Again, doens't matter what chart I am choosing,  Appreciate any help that might be out there

v-xjiin-msft Super Contributor
Super Contributor

Re: time series

Hi @tabraunlich,

 

Could you please share us a sample pbix file with One Drive or Google Drive if possible? So that we can dig deeper and find out where the issue is.

 

Thanks,
Xi Jin.