Reduce space between Y-Axis and bars in clustered bar chart

[dokat]

Hi,

I have clustered bar chart in my report and i was wondering if there is a way to reduce gap between Y-Axis and the bars. Appreciate any help. Thanks

[parry2k]

@dokat if you have added a new column as @jianlong suggested, then convert that to number and use that on x-axis.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[dokat]

@parry2k yes creating new column worked. Thank you

[parry2k]

@dokat maybe add trim/clean steps in PQ and then convert it to number:

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

[dokat]

@parry2k I tried the above method however it returned error. There are text format cells in the column like ("All Other") that returned error after trim/clean and change format type. to whole number. Please see below image of the data.  Not sure how can i change the format without getting error and reduce gap between Y-axis and bars.

[jianlong · Accepted solution]

Yeah, you have text in this column, so errors occur because the word can not be converted to number.   I would recommend that that you use :

new column =

if (package = "all other", "999", package).   After that, convert the new column to whole number and use this as axis..

[dokat]

@jianlong I created the calculated column and converted pack size value from text to number however after converting, chart format completely changed looking like below.  It is due to pack sizes range from 1 to 1440. I'd like to sort it by dollar sales so that packs with small sales pushed downt to the bottom of the chart. However i dont see an option to be able to sort the data by sales since data is converted to number format. Is there any work around this? What may caused this issue? Appreciate any help

[jianlong]

The only way to solve this is to use the newly created column as text, instead of converting to number.  You can check the difference as the sreenshot

[dokat]

@jianlong I converted back to Text format but now i am back to having same problem. where gap between bars and y-axis is too wide. I see that you don't have that problem on your chart. Are there any settings i can adjust to close that gap. Thanks

[jianlong]

It's still the space problem then.  Try  1) Convert this new column from text to number, then convert back to text, to see if the space is still there.   2) use trim/clean to remove the space

[dokat]

@jianlong Yes unfortunately it is. I tried both methods and still having the same issue. What's interesting is in certain slicer selections issue dissapears. You could see below with one slicer selection gap dissapears with other one it pops back. Thanks

[jianlong]

Well, frankly I don't know what to do now, you can post a link or your file here, so I can have a look to see what's the problem.

[dokat]

@jianlong Thank you. It will be difficult for me to share the file as majority of the data is confidential financial information. But thanks for looking into it.

[dokat]

@jianlong . Created a new column and it worked. Thank you

[jianlong]

Y axis,  12, 4 ... are text and there is too much "text space" before and after the number itself ?   First time to see this much space, regardless Y axis is text or number or not.

[dokat]

Yes it is text and it doesnt allow me to convert to a number, unless there is way you know of. Thanks

[jianlong]

1) check to see if there is any character in packages, that might not allow you tranform the text to number;

2) use transform under query editor,  under extract, use trim and/or clean, then see if everything works out

[dokat]

@jianlong Thanks for your response. Yes i tried to trim and clean and converted to whole number. The issue i came across is it returned error message for true text values in the column like "All Other" It converted numbers stored as text to number format. Thanks