Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
88 | |
68 | |
61 |
User | Count |
---|---|
152 | |
120 | |
102 | |
87 | |
68 |