Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi,
I have a SharePoint Online list that captures a couple of measurements agaist certain options. There are 10 options on the list, with 2 measurements for each.
Option 1 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
Option 2 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
Option 3 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
Option 4 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
Option 5 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
Option 6 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
Option 7 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
Option 8 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
Option 9 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
Option 10 (choice field) - Measure 1 (choice field) - Measure 2 (choice field)
How can I combine the data so that all the measurements for each of the options are analyzed as one and not seperatly (across all the fields)?
I hope this makes sense. Any help would be appericiated.
I'm not exactly sure what you are after, can you post some sample data and what you are trying to achieve?
I've attached a screenshot of the list and also PowerBI Desktop. The issue seeme to be that that the Y Axis can only be linked to do a count for 1 field, so its only ever counting the results from that 1 field, rather than all the fields added to the filter/category.
There must be another way to analyze the data from all the fields?
Are your measures all in individual columns currently? If so, I'd suggesd you unpivot your table in Query Editor... this will allow you to bring you measure name into the legend category or to use as a slicer etc
User | Count |
---|---|
96 | |
87 | |
78 | |
72 | |
68 |
User | Count |
---|---|
113 | |
105 | |
84 | |
65 | |
64 |