Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
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 the sum of item1, the sum of item2, the sum of item3, the sum of item4, and the sum of item5. I was able to achieve this using a pie graph and also a stacked column chart. How can I build a bar chart that shows the sum of each item on a separate bar for a side-by-side comparison? Finally I would like to show a data-table that shows for each item = 0.7*category1 score of Item + 0.3*category2 score of item
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,
Either unpivot your data so your columns become attributes and values, or create a measure that does what you describe, across columns.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
13 | |
2 | |
2 | |
1 | |
1 |
User | Count |
---|---|
20 | |
3 | |
2 | |
2 | |
2 |