Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
tabraunlich
New Member

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
v-xjiin-msft
Solution Sage
Solution Sage

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.

tabraunlich
New Member

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.