Forum Discussion
problem while plotting Scatter plot
Can anyone help me with plotting scatter graph for attached table? I have attached the pic of resulting graph using excel but unable to plot in power bi.
| Lower | Data | Upper |
| 300 | 433.701 | 580 |
| 300 | 445.558 | 580 |
| 300 | 443.153 | 580 |
| 300 | 432.329 | 580 |
| 300 | 453.605 | 580 |
| 300 | 450.144 | 580 |
| 300 | 473.368 | 580 |
| 300 | 436.824 | 580 |
| 300 | 436.094 | 580 |
| 300 | 451.423 | 580 |
| 300 | 446.411 | 580 |
thanks in advance!
Hi Nicks612 ,
how about this in Power BI ?
File is available here:
https://drive.google.com/drive/folders/1ycVQPKE81T15STKeIvWWrvYD7u_PQGMr?usp=sharing
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
6 Replies
Hi Nicks612 ,
how about this in Power BI ?
File is available here:
https://drive.google.com/drive/folders/1ycVQPKE81T15STKeIvWWrvYD7u_PQGMr?usp=sharing
If this helped, please consider giving kudos and mark as a solution
@me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
How to create variable indices with respect to values count when data increase or decrease? Here, in my case it is 11 but when I load more data, indices should automatically increase or decrease.
You can do it in Power Query
AddColumn -> Index
see link
https://learn.microsoft.com/en-us/power-query/add-index-column
If this helped, please consider giving kudos and mark as a solution
me in replies or I'll lose your thread
Want to check your DAX skills? Answer my biweekly DAX challenges on the kubisco Linkedin page
Consider voting this Power BI idea
Francesco Bergamaschi
MBA, M.Eng, M.Econ, Professor of BI
Hi Nicks612
Open Power Query.
Make sure the table has three separate columns:
Lower
Value (Data)
Upper
Set all columns to Decimal Number.
Add a Scatter chart.
Set:
X-Axis = Lower (or create an Index column if all Lower values are the same)
Y-Axis = Data
Size (optional) = Upper
If all Lower values are equal (e.g., 300), create an Index column and use it as the X-Axis.
Did it work? ✔ Give a Kudo • Mark as Solution – help others too!
Regards,
Rufyda Rahma | MIE
