Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

X-axis configuration 'Line and stacked column chart'

Hello,

 

Is there a possibility to turn this (current)...

 

X-axis with all values displayed

 

...into this (design), so basically hiding the labels on the x-axis for every quarter and only showing the hours:

 

 

X-axis with only hours, but all columns

Need Help

3 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Anonymous

     

    In this scenario, you need to aggregate your data on hour level to get your expected chart. You should add a column for hours in your source table. Then just drag this hour column on X-axis.

     

    Regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hello Simon,

       

      I don't think that's quite true. I tried that, but then it summarizes four columns of each 15 minutes of an hour into one column for an hour. But that's not what I want.

       

      What I want is, to still show the four columns for each 15 minutes of an hour, but only have the full hour notation (23:00, 00:00, 01:00 etc.) shown on the x-axis, exactly as it is in the design (the second picture).

       

      Do you see my predicament now? Is it possible you think?

       

      Regards,

      Robin

      • tringuyenminh92's avatar
        tringuyenminh92
        Icon for Memorable Member rankMemorable Member
        9 years ago

        Hi Anonymous,

         

        It is possible, but you have show only in duration 2 hours or less, it will be automatically scale out 15 or 10 or 5 ^_^ Basically, we could not control that duration :( 

         

        check with duration 115 minutesauto scale based on data but wrong expectation