Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
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/
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/
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?
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 ) )
Proud to be a Super User!
User | Count |
---|---|
98 | |
90 | |
83 | |
70 | |
67 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |