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

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

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
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.