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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
matdel
Helper I
Helper I

Scatter plot

Hello,

I would like to do a scatter plot in power bi, but I don't find the good way to do it.

I have two colums: one column parameter with lot of diferent parametes, and one column value like this example of tab below : 

 RAW DATAS (3).xlsx - Excel.jpg

And I would like to do a scatter plot by selecting two parameters from the column parameter that could be diferent from Calcium and phosphorus if for example, I would also want to look at Magnesium and sodium together:

 

RAW DATAS (3).xlsx - Excel_2.jpg

 

Do you know if there is a way to do it in power bi ?

Thank you!

1 ACCEPTED SOLUTION
negi007
Community Champion
Community Champion

@matdel I have created these two tables manually. But they can be created automatically like below. make sure there is no relationship between these tables.

 

Table 2 = DISTINCT('Table'[Parameter])
 
negi007_1-1619079768872.png

 


 




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



Proud to be a Super User!


Follow me on linkedin

View solution in original post

9 REPLIES 9
matdel
Helper I
Helper I

another question, how have you created the two tables para_tab ? Are they automatical or did you create them manually ?

thnaks!

negi007
Community Champion
Community Champion

@matdel I have created these two tables manually. But they can be created automatically like below. make sure there is no relationship between these tables.

 

Table 2 = DISTINCT('Table'[Parameter])
 
negi007_1-1619079768872.png

 


 




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



Proud to be a Super User!


Follow me on linkedin

Thank you!! it works well 🙂

negi007
Community Champion
Community Champion

@matdel 

 

pl. create two measures

 

Calcium = CALCULATE(SUM('Table'[Value]),'Table'[Parameter]="Calcium")
Phopshorus = CALCULATE(SUM('Table'[Value]),'Table'[Parameter]="Phopshorus")
 use these two measures in x-axis and y-axis like below
 
negi007_0-1619013554837.png

 

let me know if you are looking for something else. pbix file attached below

 



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



Proud to be a Super User!


Follow me on linkedin

Hello, yes this solution works if I use only those two parameters. But my problematic comes from that those two parameters are variable. I would like to change them and not necessary use calcium and phosphorus.

In the column parameter, I have also others like : magnesium, sodium, Iron,... and I would like to be able to change easily the parameters used in the graphics

negi007
Community Champion
Community Champion

@matdel in this case I have modified my pbix file and now you can select two parameter. one for x-axis and one for y-axis. 

 

negi007_0-1619015876116.png

 

 

 

let me know if it works for you or not. thanks




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



Proud to be a Super User!


Follow me on linkedin

Ok great!! I will try thank you so much!

amitchandak
Super User
Super User

@matdel , you have only two columns. Value of both X and Y-axis

parameter as legend and index column as details 

 

https://stackoverflow.com/questions/45715963/creating-an-index-column-for-power-bi

hello, yes i forgot that I have also a column Batch number

Dig NA.csv - Excel.jpg

But it doesn't work, even when I put Batch number in details.

I would like to have the values of the calcium on the X axis and the value of the phosphurus on the Y axis.

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.