Forum Discussion
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 file, no confidential information inside:
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
1 Reply
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