ClockHour on X-Axis: Categorical vs Continuous

[rsbin]

Good Day,

I have a calculated column based on 24-hour clock formatted as Time (hh:nn).

I want to create a "Continuous" line chart, but when I apply this column as my x-axis, I get time in AM / PM format.

If I change to "Categorical", I get my 24 hour clock, but, I do not get the continuous line chart that we desire.

I want the line chart from the first graph with the x-axis from the second.   Any help with accomplishing this would be appreciated!

Thanks and Kind Regards,

[lkalawski · Accepted solution]

Hi @rsbin 

To achieve it you need to change/add new measure and use IF(ISBLANK([name]),0,[name]).

Currently, you don't see this Blank data for a few hours if you add this condition then you will see the line.

Proud to be a Super User. If I helped, please accept the solution and give kudos!  Linkedin

[rsbin]

@lkalawski 

Thank you for the response!  I believe you have solved my problem.

Best Regards,