Forum Discussion
Solved
Un-Summarize column, calculated rows?
Visual bar charts with 'Auto' Y axis cut the upper data bar in half. I am trying to add padding to the data by adding a null value in the table so it pads the visuals. Name SubGroup Size ...
I would take a slightly different approach to this.
Create two measures one for padding the sub-group and one for padding the size.
PaddedSubGroup = MAX('Table'[SubGroup]) * 1.1PaddedSize = MAX('Table'[Size]) * 1.1Use these measures in the respective axis 'End' fields to create the padding you need. That way you don't need to create any dummy data. Make sure to set the 'Start' value to zero also.
(see attached PBIX file)
(I may be misunderstanding your issue. If so, can you post an image of your visual?)
Hope this helps.
Make sure both the Subgroup and Size columns are not summarized in both the table and the field bucket of the visual. You might also need to select the option for "Show items with no data" in the field bucket for the visual