Solved: My scatter plot doesn't work

Anonymous · ‎11-21-2020

Hey everyone,

My scatter plot doesn't work accordingly I think it might be a relationship problem, could any of you try to solve the issue and explain me what the problem was?

Here is the file, no confidential information inside:

Scatter Plot

mahoneypat · ‎11-21-2020

It would be better to change your model to create a country table with country code column that connects to your tables with country data. However, this measure expression works with your current model. Use it on your Y axis, format it as a %, and change the Y max back to auto.

Unemp Rate Treatas =
CALCULATE (
    AVERAGE ( 'Unemployment Rate'[Unemployment Rate] ),
    TREATAS (
        VALUES ( 'GDP Per Capita'[Country Code] ),
        'Unemployment Rate'[Country Code]
    )
)

Regards,

Pat

Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.

@mahoneypa HoosierBI on YouTube

View solution in original post

mahoneypat · ‎11-21-2020

It would be better to change your model to create a country table with country code column that connects to your tables with country data. However, this measure expression works with your current model. Use it on your Y axis, format it as a %, and change the Y max back to auto.

Unemp Rate Treatas =
CALCULATE (
    AVERAGE ( 'Unemployment Rate'[Unemployment Rate] ),
    TREATAS (
        VALUES ( 'GDP Per Capita'[Country Code] ),
        'Unemployment Rate'[Country Code]
    )
)