Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Scatter Chart - X and Y text value axis, Z numeric axis

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

Freaz_0-1669278224331.png

Target result

Freaz_1-1669278658671.png

Freaz_2-1669278689596.png

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

2 ACCEPTED SOLUTIONS
MFelix
Super User
Super User

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

MFelix_0-1669317757115.png

  • 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

Result is below:

MFelix_1-1669317853764.png

 

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:

MFelix_2-1669318003751.png

 

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:

MFelix_3-1669318285575.png

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

Hi @Anonymous ,

 

On the Index column select the summarization of sum:

MFelix_0-1669369014762.png

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

4 REPLIES 4
MFelix
Super User
Super User

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

MFelix_0-1669317757115.png

  • 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

Result is below:

MFelix_1-1669317853764.png

 

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:

MFelix_2-1669318003751.png

 

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:

MFelix_3-1669318285575.png

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

Hi @MFelix ,

 

Thanks a lot for your answer. I tried your solution but it returns me the following error :

Freaz_0-1669363700716.png

 

Have I done something wrong?

 

Here's what I put in the chart's fields and the updated table with an index column :

Freaz_1-1669363767674.png

Freaz_2-1669363800791.png

 

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:

MFelix_0-1669369014762.png

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


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



@MFelix , so simple yet so accurate 🙂

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors