I have 3 tables:
1) Size_table with columns ID_lower and Size (number):
ID_lower Size
Name 1 1
Name 2 5
Name 3 8
2) Key_table with columns ID_higher and ID_lower where same ID_lower can correspond to multiple ID_higher:
ID_higher ID_lower
Upper 1 Name 1
Upper 2 Name 1
Upper 3 Name 3
3) Parameter_table with columns ID_higher and Value (number). This table would however contain only first Upper value if there are multiple Uppers with same ID_lower (that is, it would contain Upper 1 but not Upper 2). This is because of the nature of data collection.
ID_higher Value
Upper 1 67
Upper 3 90
I related the table ID_lower from size_table to ID_lower in key_table and ID_higher in key_table to ID_higher in parameter_table. PBI sets relations many to many by default.
I am trying to plot scatter with size (size_table) on x and Value (parameter_table) on y and ID_higher (key_table) as legend. I can only see Upper 1 and Upper 3 on my graph. How can I get upper 2 to show there (I realise the dot would be in exactly same spot as Upper 1 though)? No matter which filtering direction I choose I end up without Upper 2 on my scatter plot or I end up with skewed up data.
