Skip to main content
cancel
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

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

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