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.
This is a sample dataset by repondent with answers from a survey (Range from 1 to 5). A group of 2 or more questions measures a dimenion (See colored cells below).
I am able to create basic visuals like the chart 1 below which shows the average of the total percentage of each respondant by dimension (colored cells below) by creating two measures, one to get the percentage of total points by dimension (i.e. (question1 + question2)/10 ) and the other to get the average of the first measure (total percentage by respondent). I need help creating a visual like the Chart 2 below that has different measures in the legend while using other measures in the axis. I have tried all I could find online including creating two measures that use values from two tables to make sure I can use those values in an axis (See measures and tables below) which works in part but the numbers just repet themself in each view of the chart. The idea is to get something like the chart 3 at the end of this post that will let me slice by dimension.
Measure 1
Measure 2
Table 1
Table 2
Your help and time will be appreciated as I already spent the entire week trying to find a solution with no success.
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 |
---|---|
96 | |
95 | |
80 | |
74 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |