Scatter plot

[matdel]

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 : 

 

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:

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

Thank you!

[matdel]

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

thnaks!

[negi007 · 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])

[matdel]

Thank you!! it works well 🙂

[negi007]

@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

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

[matdel]

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]

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

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

[matdel]

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

[amitchandak]

@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

[matdel]

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

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.