Relationship between tables

[Gregwoolley2387]

Hello 

I have 3 tables of data that I'm looking to refer to. All of which have column for 'Year' and 'Scheme Name', amongst other data points.

I would like to be able to apply a slicer for 'Year' and 'Scheme Name' in my report, but I'm finding that I when I select a Year slicer, it only cuts the data which has come from the table where that particualr Year column was selected.

My understanding is I need to create a relationship between the tables but I'm not sure how to do this correctly. I've been presented with the 'unique values...' error message when attemtping to do so.

The file can be viewed here: 

https://app.powerbi.com/view?r=eyJrIjoiZDVmMjg0MzMtMDU2OS00N2UxLThmYjQtOTI1MTQwZWQ4MjJhIiwidCI6IjdkN...

Really appreciate any help.

Thanks, Greg

[v-yuezhe-msft · Accepted solution]

@Gregwoolley2387,

I am unable to see the file you shared. In your scenario, if you get error message "You can’t create a relationship between these two columns because one of the columns must have unique values" when creating relationship, please review this blog to solve this issue.

If you still don't get expected result, please share sample data of your tables for us to analyze.


Regards,
Lydia

[Gregwoolley2387]

Thank you Lydia. The blog was helpful.