Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to 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.
Proud to be a Super User!
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.
Proud to be a Super User!
Thank you!! it works well 🙂
pl. create two measures
let me know if you are looking for something else. pbix file attached below
Proud to be a Super User!
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
Ok great!! I will try thank you so much!
@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
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.
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |