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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
GeekAlfPro
Resolver II
Resolver II

X-axis hours fixed

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 : 

 

GeekAlfPro_0-1646561757779.png

 

GeekAlfPro_1-1646561781111.png

 

Thanks !

5 REPLIES 5
GeekAlfPro
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.

@GeekAlfPro 

 

Can you share the pbix with dummy data?

mhossain
Solution Sage
Solution Sage

@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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.