Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

My scatter plot doesn't work

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 f...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    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

     

mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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