Forum Discussion
visualizing running total for non-data value with zero values
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
How should I do that?
Community SupportHi 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
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.
- v-deddai1-msft
Hi Anonymous ,
Based on my research, When we put those number and Date/Time data into X-Axis, the Type option would show up in Format, with Continuous, Categorical available.
Continuous axis is where values change continuously and you cannot count the number of different values. Examples include weight, price, counts etc. It means the X-Axis would show the data in a natural growth order, like 1,2,3,…… regardless of the Y-Axis data Basically anything you can measure or count.
Categorical is where you make small number of categories. This includes type, gender, age group, etc. Categorical would only show the part which have values based on Y-Axis, those part of X-Axis with no values in Y-Axis, would be removed.
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