Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
94 | |
86 | |
82 | |
70 | |
49 |
User | Count |
---|---|
143 | |
122 | |
109 | |
60 | |
55 |