X-axis hours fixed

[GeekAlfPro]

Hi,

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 !

[GeekAlfPro]

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.

---

[mhossain]

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?

[GeekAlfPro]

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.

[mhossain]

@GeekAlfPro 

Can you share the pbix with dummy data?

[mhossain]

@GeekAlfPro 

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.