Making clustered bar graph in power bi

[asadmustafa]

Hi there,

I am using the following version of Power BI: Version: 2.117.984.0 64-bit (May 2023)

I am trying to create a clustered Bar graph. I have the following fields which I want in my bar graph: 'Title', 'Actual Cost' and 'Estimated Cost'.

Against each 'Title', there is an 'Actual Cost' and an 'Estimated Cost'. For instance, for 'Title' named 'Enda', the 'Actual Cost' is '660.33' and 'Estimated Cost' is '745'. I want to make a comparison in the Bar graph to show Actual and Estimated costs against each title.

When I am trying to do it, it puts my Title in X-Axis and anything that goes into the Y-axis turned into the Count, instead of the actual value. When I ry to convert it into value, it doesn't have any option for that. 

Please help me in this regard.

Thanks

[ppm1 · Accepted solution]

Are your two cost columns set to a numeric data type? or text?

Pat

[asadmustafa]

Ahh thanks a million Pat, I just changed my data type to Decimal and it's working now.

Thanks again!