Forum Discussion
Report charts difficulties
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
Hi Anonymous ,
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
2 Replies
two charts I am trying to replicate in Bi service report, from excelPower 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.
Hi Anonymous ,
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
