Forum Discussion

asozanska's avatar
asozanska
New Member
1 year ago
Solved

Cluster bar chart - Bar width

I have read all the posts about this topic but I don't think there is a solution to have a cluster bar width customised to my needs, regardless of the number of categories in the Y chart. There is th...
  • danextian's avatar
    1 year ago

    Hi asozanska 

    There's an option to increase/decrease the space between series and categories.

    Here is how my chart looks like at the moment, the labels are squeezed, some not visible. I want to have a way to increase the width of each bar and space between them - you mean to add a gap between the longest bar and the end of the visual? If so, you can write a measure that checks the max value of all the selected categories in the chart and multiply that by a number.

    Max Sales Amount Bar Width = 
    MAXX ( ALLSELECTED ( 'Date'[Month Short] ), [Sales Amt] ) * 1.5
    

     Use that as the dynamic max range of the X-axis. Notice that there's quite a gap after the Nov blue bar.