Forum Discussion
Line graph axis when using date hierarchy
Hi, I have a line graph and when I make the axis 'date' it presents the data in ascending date order If however I use the Date Hierarchy on the same date table the order is reversed and there ...
Check your date/time column to see if it is in sort descending status. If it is, go to your chart that using data hierarchy and see if you have selected sort by date/time option.
Thanks Jessica,
Perhaps I should have said; the data source is SSAS Tabular so in Power-bi I dont the option to sort the data.
I tried sorting it both ways in SSAS and it made no difference.
On the graph - the only option is to 'Sort by Year/Quarter' Z-to-A.
Just like in your example. How would you alter your example to go from Jan to December ?
JC