Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

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.

Reply
moroformat0319
Regular Visitor

Creating visuals with measures

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.

 

moroformat0319_2-1678473169616.png

Measure 1

moroformat0319_3-1678474307073.png 

Measure 2

moroformat0319_5-1678474403591.png

 

Table 1

moroformat0319_4-1678474356463.png

Table 2

moroformat0319_6-1678474435179.png

 

moroformat0319_7-1678474575039.png

 

Your help and time will be appreciated as I already spent the entire week trying to find a solution with no success.

 

0 REPLIES 0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.