cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rsbin
Post Patron
Post Patron

ClockHour on X-Axis: Categorical vs Continuous

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.

 

image.png

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

image.png

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,

 

1 ACCEPTED SOLUTION
lkalawski
Super User II
Super User II

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.

 

PBI_SuperUser_Rank@1x.png Proud to be a Super User.
If I helped, please accept the solution and give kudos
Linkedin

 

View solution in original post

2 REPLIES 2
lkalawski
Super User II
Super User II

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.

 

PBI_SuperUser_Rank@1x.png Proud to be a Super User.
If I helped, please accept the solution and give kudos
Linkedin

 

View solution in original post

@lkalawski 

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

 

Best Regards,

Helpful resources

Announcements
MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Top Solution Authors
Top Kudoed Authors