Don't miss your chance to take the Fabric Data Engineer (DP-600) exam for FREE! Find out how by attending the DP-600 session on April 23rd (pacific time), live or on-demand.
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. 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
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
| User | Count |
|---|---|
| 46 | |
| 43 | |
| 39 | |
| 19 | |
| 15 |
| User | Count |
|---|---|
| 68 | |
| 67 | |
| 31 | |
| 27 | |
| 24 |