Report charts difficulties

[HEW1]

Hi,

I currently have two charts I am trying to replicate in Bi service report, from excel data that has been imported into the report, and I can not seem to replicate it, I have tried putting the columns selected into different x and y axis and instead of getting values, it counts?

Excel charts below I would like to replicate and the result I get in the BI report. Thanks

Excell charts

Report Table

Report Chart

[Anonymous · Accepted solution]

Hi @HEW1 ,

Please note that the Y-axis of your bar chart is currently set to 'Count'. Based on your description, I believe you are aiming for a 'Sum' instead. Kindly check if the data type of your column is numeric, and then adjust the aggregation method to 'Sum' to achieve the desired result.

Kindly check if the data type of your column is numeric, and then adjust the aggregation method to 'Sum' to achieve the desired result.

Best Regards,

Bof

[lbendlin]

two charts I am trying to replicate in Bi service report, from excel

Power BI is not Excel.  Stop "fighting the API"  and instead focus on the story you want to tell and the insights you want to provide to your users. Based on that, use the most appropriate Power BI visual.