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.

parry2k's avatar
parry2k
Super User
7 years ago

Mann you are taking right approach by adding sort column and then sorting your time colum with "sort" column, it is expected to work. Can you share you pbix by chance to further look into it?

Mann's avatar
Mann
Resolver III
7 years ago

Hi Parry,

 

Thanks for connecting on this. Sorry couldn't reply on this yersterday.

I have created a Test.pbix file and placed it here Test.PBIX. It also contains two sample files I am using as a source to this pbix file.