Forum Discussion

GeekAlfPro's avatar
GeekAlfPro
Helper V
4 years ago

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 : 

 

 

 

Thanks !

Need Help

5 Replies

  • mhossain's avatar
    mhossain
    Solution Sage
    4 years ago

    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.

  • GeekAlfPro's avatar
    GeekAlfPro
    Helper V
    4 years ago

    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's avatar
      mhossain
      Solution Sage
      4 years ago

      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's avatar
        GeekAlfPro
        Helper V
        4 years ago

        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.