Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to 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
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
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.
User | Count |
---|---|
42 | |
25 | |
22 | |
20 | |
17 |
User | Count |
---|---|
54 | |
43 | |
24 | |
21 | |
21 |