problem while plotting Scatter plot

[Nicks612]

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!

[v-tejrama]

Hi @Nicks612 ,

Thank you @ryan_mayu  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you.

[ryan_mayu]

@Nicks612 

in power query create an index column

then you don't need to create any measures

just turn off the line for data and turn on the markers

pls see the attachment below

[FBergamaschi · Accepted solution]

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

[Nicks612]

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.

[FBergamaschi]

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

[Rufyda]

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