Forum Discussion
Scatter Chart - X and Y text value axis, Z numeric axis
- 3 years ago
Hi Anonymous ,
On the scatter plot relates to variable so when you have an increase in the value of one you can check the other one variation.
Using the standard value on PBI what you can do is the following:
- Add an ID column for each colour of t-shirt
- Now create your Scatter plot with the following settings:
- X-axis - X-axis column - no summarization
- Y-Axis - Type column
- Legend - Y-axis column
- Size - Creation time column
- Y-axis max - 5
- Y-axis min - 0
- X-axis - X-axis column - no summarization
Result is below:
Now what you can do is to force the colour on each of value and turn off the y-axis and the legend final result like this:
If you want to have the values on each of the rows you can add a text field in front of each one with the text and doing a group of the visualizations will seem like a single visual:
- 3 years ago
Hi Anonymous ,
On the Index column select the summarization of sum:
The size of the bubles should be the sum of the Creation Time Spent.
Regarding the data labels there is not that option on the scatter plot.
Hi Anonymous ,
On the scatter plot relates to variable so when you have an increase in the value of one you can check the other one variation.
Using the standard value on PBI what you can do is the following:
- Add an ID column for each colour of t-shirt
- Now create your Scatter plot with the following settings:
- X-axis - X-axis column - no summarization
- Y-Axis - Type column
- Legend - Y-axis column
- Size - Creation time column
- Y-axis max - 5
- Y-axis min - 0
- X-axis - X-axis column - no summarization
Result is below:
Now what you can do is to force the colour on each of value and turn off the y-axis and the legend final result like this:
If you want to have the values on each of the rows you can add a text field in front of each one with the text and doing a group of the visualizations will seem like a single visual:
Hi MFelix ,
Thanks a lot for your answer. I tried your solution but it returns me the following error :
Have I done something wrong?
Here's what I put in the chart's fields and the updated table with an index column :
I also have another question, how to display the size value within the dots?
Have a nice day.
Freaz
- MFelix3 years ago
Super User
Hi Anonymous ,
On the Index column select the summarization of sum:
The size of the bubles should be the sum of the Creation Time Spent.
Regarding the data labels there is not that option on the scatter plot.
- JoaoMarcelino3 years ago
Responsive Resident
MFelix , so simple yet so accurate 🙂