Forum Discussion

smore's avatar
smore
Advocate I
4 years ago
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 ...
Need Help
  • KNP's avatar
    KNP
    4 years ago

    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.1
    PaddedSize = MAX('Table'[Size]) * 1.1

     

    Use 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.

KNP's avatar
KNP
Super User
4 years ago

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.1
PaddedSize = MAX('Table'[Size]) * 1.1

 

Use 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.

smore's avatar
smore
Advocate I
4 years ago

This was the original approach I wanted to take but did not have function capability for the Y or X axis. Seeing your screenshots made me realize that I have to update Power BI Desktop. I now have the FX capability for Y and X axis and your measure works perfectly. Thank you for the help!