Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Resolver II
Resolver II

X-axis hours fixed


i've a graph with hours on X-axis.

i'm looking for the way to fix range on 00:00 to 24:00 even if there no data between 00:00 et 07:00 for example.

on my graph the axis changes depending on the datas : 






Thanks !

Resolver II
Resolver II

Hello @mhossain ,


thanks for your proposal, but unfortunately, i don't want to have values = to 0.

Maybe have i to create a table with hours ?

Is that what you suggest when you say : 


I guess, hours on the x axis coming from some mapping table and you have 0 to 24:00 all hours.


Hello @GeekAlfPro 


Yes, mapping table is required with all the hours.

So for the hours you don't have value what do you want to show?

yes, that's it, for some items, i have values for others, not.

that's why i want to fix the scale of hours.

i created a time table, but without success.



Can you share the pbix with dummy data?

Solution Sage
Solution Sage



I guess, hours on the x axis coming from some mapping table and you have 0 to 24:00 all hours.
In the measure for the value you can add IF(ISBLANK(measure),0,measure).

Hope above helps.

You can share the dummy pbix if above is not clear.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors