cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
matdel
Frequent Visitor

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

@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 here


View solution in original post

9 REPLIES 9
matdel
Frequent Visitor

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

thnaks!

@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 here


View solution in original post

matdel
Frequent Visitor

Thank you!! it works well 🙂

negi007
Super User II
Super User II

@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 here


matdel
Frequent Visitor

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

@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 here


matdel
Frequent Visitor

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

amitchandak
Super User IV
Super User IV

@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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors