Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi everyone,
I want to make a scatter chart having for X-axis text values and for Y-axis text values too. Of course, I need a numerical value which would be on the size (Z-axis).
In order to illustrate what I'm looking for, I put you some screenshots of what I would like to achieve:
Fictious Sample
Target result
What I wish to do is realizable on Qlik. It is called Grid Chart. (screenshot of the Target Result above)
Is it possible to do it on Power BI?
I haven't found any way to do it until now. Do you have any ideas/solutions for me?
Thank you for your help,
Freaz
Solved! Go to Solution.
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:
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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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:
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:
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsStarting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
88 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
87 | |
70 | |
66 |