Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
Hello,
I'm trying to combine different measures into the same graph. Currently, my dataset looks like this:
I have measures that calculate the average for each industry at each timeframe:
Score =
AVERAGEX(
KEEPFILTERS(VALUES('Data'[Industry])),
CALCULATE(AVERAGE('Data'[Score]))
)
Score (1mthago) =
AVERAGEX(
KEEPFILTERS(VALUES('Data'[Industry])),
CALCULATE(AVERAGE('Data'[Score (1mthago)]))
)
YTM =
AVERAGEX(
KEEPFILTERS(VALUES('Data'[Industry])),
CALCULATE(AVERAGE('Data'[YTM]))
)
YTM (1mthago) =
AVERAGEX(
KEEPFILTERS(VALUES('Data'[Industry])),
CALCULATE(AVERAGE('Data'[YTM (1mthago)]))
)
I'm trying to create a graph that looks like this:
However, I am unable to put the measures into the same scatter plot. Instead, I am currently overlaying 3 seperate scatter plots to achieve this graph. Are there anyway to combine these measures into the same visual?
I have uploaded sample data here: https://drive.google.com/file/d/17MYxjTzoqZxxKdHFdtM5drRZo-0jbWz-/view?usp=sharing
Thank you
@Deermeat , You are using both details and legend. If you use one of them you can create a calculation group on these measures and use that either on details or legend
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.