Forum Discussion

Gregwoolley2387's avatar
Gregwoolley2387
Regular Visitor
8 years ago
Solved

Relationship between tables

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=eyJrIjoiZDVmMjg0MzMtMDU2OS00N2UxLThmYjQtOTI1MTQwZWQ4MjJhIiwidCI6IjdkNzkzOGUxLTdlODctNGRiMi05MGE1LTY5MWQ3OTUwYTNiNyJ9 

 

Really appreciate any help.

Thanks, Greg

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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