Forum Discussion

rythm's avatar
rythm
New Member
5 years ago

Charts using SP List Data source and Power BI desktop

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,

 

 

Show and Tell
Tips and Tricks

1 Reply

  • rythm's avatar
    rythm
    New Member
    5 years ago

    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.