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 ...
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
v-yuta-msft
Community Support
Community SupportHi jc508,
What's the data type of the date column in SSAS? If they are text, please convert to date and try again.
Regards,
Jimmy Tao