Graph Show all X Axis

[Anonymous]

Hi everyone,

I just need a little help,

When i make a graph for my data its missing other Hour (x Axis).

see below, on the graph format, i choose a Categorical Type. And show this results.

Below Results Show a X Axis Type of "Continuous" which is something I'm looking for but it doesnt show all the numbers on the X axis which is the hour from Hour 0 to Hour 23. And thats what i need i need the graph to show all the numbers from 0 to 23.

Thanks, Hope it makes sense.

thanks

Christian

[dax · Accepted solution]

Hi pamboys09,

You could try to create a table for x-axis, then create measure like below

Measure = SUM('Table (2)'[amount])+0

You could refer to my sample for details.

Best Regards,
Zoe Zhi

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.