Charts using SP List Data source and Power BI desktop

[rythm]

Hi,

I have a SharePoint list with 5 number columns (item1, item2, item3, item4, item5) and a category choice column with values category 1 and category 1. 

I would like to use Power BI desktop to build a graph that shows sum of item1, sum of item2, sum of item3, sum of item4 and sum of item5. It can be abar graph or pie chart. I would like to group the results by category 1 and category 2. How can I achieve this using power BI desktop? I am using a SharePoint 2019 list.  Can anyone please list the steps to achieve this?

Thanks in advance,

[rythm]

Hello, 

I was able to do this using a Pie Chart. However, not with a bar chart. The default Bar chart stacks all column values in One Graph.