Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
HI there,
I have a dataset where one column has two rows with the same value in it (shown in the image below where there are two '6' values). This means that when I plot the values (within the details section, not x axis) on a scatter graph they go on top of each other on the y axis, despite having different y axis values (each point is valued at 6,5,4,3,2,1 to keep the linear formation for the visual).
Is there a way to ensure that even if the values are the same, they remain separated on the y axis?
I've noticed this combination of same values occurs in other instances too, such as if I have a multicard with two of the same words in it, it aggregates the rows into. I've tried not summarizing the metric but that doesn't work.
Thanks!
Solved! Go to Solution.
Hi @Anonymous ,
According to your description, I think you need to enable other axis or legend field to grouping measure result with different fields.
Regards,
Xiaoxin Sheng
HI @Anonymous ,
I'm not so clarify for your data structure, can you please share some sample data to help use clarify your requirement.
In addition, you can consider to write a measure formula to summarize result based on current group.
Measure = CALCULATE ( SUM ( Table[Amount] ), ALLSELECTED ( Table ), VALUES ( Table[Category] ) )
Regards,
Xiaoxin Sheng
Hi Xiaoxin,
Thanks, I don't think a measure would work as I really need a calculated column so that the problem doesn't occur again when the data is updated each week. I don't want to have to manually add a circle using the measure when the problem occurs, I would like the scatter graph to keep two of the same values separate automatically.
Below are two examples of my data. The column on the right has two of the same values (6 and 6). It is this duplication that causes the scatter plot circles to fall on top of each other. The image attached also shows how I input the metrics into the scatter graph
Story | Sort Order | Avg Engagement | Avg Engagement |
Daily Mirror | 6 | 5 | 5 |
Daily Mail | 5 | 132 | 132 |
The Sun | 4 | 17 | 17 |
Daily Star | 3 | 0 | 0 |
The Star | 2 | 6 | 6 |
The Mirror | 1 | 355 | 6 |
I hope this helps. Thanks,
Finny
Hi @Anonymous ,
According to your description, I think you need to enable other axis or legend field to grouping measure result with different fields.
Regards,
Xiaoxin Sheng