Forum Discussion

tabraunlich's avatar
tabraunlich
New Member
8 years ago

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

  • tabraunlich's avatar
    tabraunlich
    New Member
    8 years ago

    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's avatar
    v-xjiin-msft
    Solution Sage
    8 years ago

    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.