Use whole number and percent in same column report

[Anonymous]

Hi,

I am using column chart to show normal column (whole number) and percent in same report. The percent column shows very tiny not as expectd. Is there a way to meet this requirement?

Edit: table is simple having 2 columns as whole number and one calculated column which shows percent of both columns

[az38 · Accepted solution]

@Anonymous 

it's because, originally, your percentage is stored as 0.625 and 62.5% is just a represent format

to correct visualization all your bars should have the same store format

[az38 · Accepted solution]

@Anonymous 

it's because, originally, your percentage is stored as 0.625 and 62.5% is just a represent format

to correct visualization all your bars should have the same store format

[Anonymous]

@Super User II Thanks.. If i remove the representation ; i do not get % sign in the chart. Any suggestions how to make that happen?

[az38 · Accepted solution]

@Anonymous 

sorry, I still do not understand the idea to show percentage and number in the same bar chart.

It's completely incorrect from the best practices view.

I highly recommend you to change data visual format to more appropriate, e.g. Line and stacked column chart