Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! 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
| User | Count |
|---|---|
| 51 | |
| 40 | |
| 29 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 64 | |
| 57 | |
| 40 | |
| 21 | |
| 19 |