Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors