Forum Discussion

Mann's avatar
Mann
Resolver III
7 years ago
Solved

Custom Sorting the x-axis with time value

Hi All, I created a simple line graph with Time values in X axis and Measure dropped to value area as shown. X axis: Column "Time" coming from Table A having time values like (08:00 AM, 08:05 AM,...
Need Help
  • Mann's avatar
    Mann
    7 years ago
    Hi Parry,

    Thanks for the reply. If I make x axis categorical then it extends the length of x axis which is not the requirement. So instead of using time value on x-axis, I used date time column and used a time slicer. Everytime user selects any date or date range graphs changes accordingly but keeps continuous x axis.

v-piga-msft's avatar
v-piga-msft
Resident Rockstar
7 years ago

Hi Mann,

 

Please have a try if you change the type of the X axis to be categorical.

 

In addition, if it is convenient, could you share your data sample which could reproduce your scenario so that we can copy and test.

 

Best  Regards,

Cherry

  • Mann's avatar
    Mann
    Resolver III
    7 years ago

    Thanks Cherry for reaching out.

     

    I have shared the test file link in my post. Categorical won't help because x-axis is having data values for every 5 min for 24 hours. It will make this axis long. I am trying to achieve this using continuous only.

    • Mann's avatar
      Mann
      Resolver III
      7 years ago

      Hi Guys,

       

      Just checking in if this is something which we can't achieve in Power BI? Please let me know what you think?

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        see if this is what you had in mind:

         

         

        Key here is use the the Movement Hour from yoru Order table in the chart, be sure to sort that column  by your sort column in that table, and keep the formatting as text.  When switched to a time it defaults to 12:00:00 for some reason.