Forum Discussion

jc508's avatar
jc508
Frequent Visitor
8 years ago

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 is no option to reverse the order

Any idea how can I get the hierarchy view into the proper order ?

 

Date AxisHierarchy Axis

Need Help

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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.

     

     

     

     

    • jc508's avatar
      jc508
      Frequent Visitor
      8 years ago

      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's avatar
        v-yuta-msft
        Community Support
        8 years ago

        Hi 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