Removing blank spaces

[Anonymous]

Hi,

I'm creating a clustered Colomn chart. However As can be seen in screenshot 1 there is a lot of blank space on the right an left. In screenshot 2 you can see that I have a filter on the country and there are multiple data in the Y-axis. How can I remove the white space so that the bars are spreaded over the full with?

Thanks in advance!

[pratyashasamal]

Hi @Anonymous ,

You can adjust the white space with "Minimum category width"  option available in Format -> Y Axis / X axis-> Minimum category with.

You just have to increase the value of minimum category width. 

I tried this on Clustered bar chart and its works for me.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[Anonymous]

Hi Pratyasha,

Thank you for your response but I can not find the "Minimum category width". See the screenshot attached

[pratyashasamal]

Hi @Anonymous ,
You can find Minimum category width     under Visual >Column >Spacing.
Thanks ,
Pratyasha Samal

[pratyashasamal · Accepted solution]

Hi @Anonymous ,
Try to make Type as Continuous and make Range as auto.

Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[Anonymous]

Hi @pratyashasamal 

I don't have that option??

Also I have multiple values on the Y-axis. Could that be a problem?

I have attached the dataset. 

[pratyashasamal]

Hi @Anonymous ,
Yes i think so , that might be the issue . I tested it will multiple column in Y axis and i am facing the same issue. And I am also unable to find any solution to it .
I would suggest to you may submit this idea in Power BI Ideas to help us improve Power BI. Thanks a lot!
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C