Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

visualizing running total for non-data value with zero values

Hi In my project, instead of a daily calendar, I created a shift-calendar which starts from 5 am to 5 pm and 5 pm to 5 am. For each shift, I have a row number (shift number: 1 to .... which is numbe...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi Anonymous ,

     

    Please refer to the screenshot below:

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

PaulDBrown's avatar
PaulDBrown
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous 

Try changing the x-axis to "categorical"

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    How should I do that?

    • v-deddai1-msft's avatar
      v-deddai1-msft
      Icon for Community Support rankCommunity Support
      5 years ago

      Hi Anonymous ,

       

      Please refer to the screenshot below:

       

      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

       

      Best Regards,

      Dedmon Dai

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        Thanks for the help. It gives me some more flexibility but cannot show the values with Zero and removes them. I figured it out in the other way. I added a column with Time format to my table and instead of using Shift Name, I used that value in continuous style.

        It is not 100% but solved my issue.