Forum Discussion
Scatter Plot: Multiple data points at the same place
Hi,
I'm pretty new to Power BI and need help with a problem I've encountered. I have a sharepoint list about Software Use Case Ideas. Every Use Case has a long and short description. My boss wants these use cases categorized on 2 dimensions: Office <-> Business and External <-> Internal. I've assigned values in these categories from -100 to 100 for each Use Case. Problem is: Some UseCases have the same X and Y coordinates. For example:
| X | Y | UseCase |
| -50 | 20 | UC 1 |
| 100 | 30 | UC 2 |
| 50 | 50 | UC 3 |
| 50 | 50 | UC 4 |
I want to visualize this data in a scatter plot. This works very well, but the problem is, that when I hover on a UseCase it only shows me one Use Case, instead of all Use Cases at the same point.
My first idea was that I create a ToolTip/QuickInfo site, that shows me all Use Cases at this spot. Sadly I didn't manage to get the result I wanted.
My second idea was to create a separate column that includes all short descriptions from datapoints at the same point as the point I'm hovering on. Here I didn't really know, how to do such a formula.
Can anybody help me with one of these ideas or has a third idea they can show me? Thanks in advance
I was able to find a solution myself. I combined the coordinates in one column like this "X###Y###" and then created a second tabled where I grouped the rows at the same coordinates using this tutorial: https://gorilla.bi/power-query/group-by-to-concatenate-text/
3 Replies
Create a measure like this and add it as a tooltip. It displays each UseCase on a separate line.
Tooltip Measure = CONCATENATEX ( Table1, Table1[UseCase] & UNICHAR ( 10 ) )Hello DataInsights,
thanks for your answer. Sadly this doesn't solve my problem completely, because it adds the Use Cases of all lines. How do I need to write the filter, that it only adds the Use Cases at the same X and Y coordinates?
I was able to find a solution myself. I combined the coordinates in one column like this "X###Y###" and then created a second tabled where I grouped the rows at the same coordinates using this tutorial: https://gorilla.bi/power-query/group-by-to-concatenate-text/
