Forum Discussion
How to create relationship between two tables
| Model Name | Problem | Value |
| A | Size | 10 |
| B | Size | 5 |
| C | Color | 3 |
| E | No Issue | 2 |
| E | Color | 1 |
| Model Name | Value | Qty |
| A | 1 | 100 |
| A | 2 | 30 |
| C | 3 | 1 |
| D | 10 | 3 |
| C | 4 | 2 |
I would like to create a slicer that filter by Problem . How to create relationship between these two tables?
ex:
A Problem Slicer, visualize in a table or chart show value/qty in model level and different problems
Now im facting an issue that problem doesnt filter table 2 only filter table 1
9 Replies
Hi SelflearningBi ,
I would suggest you to create a one to many relationship between Table 1 and Table 2 on basis of Model Name.
To Create relationship manually :-On the Modeling tab, select Manage relationships > New.
In the Create relationship dialog box, in the first table drop-down list, select a table. Select the column you want to use in the relationship.
In the second table drop-down list, select the other table you want in the relationship. Select the other column you want to use, and then select OK.
Please follow this link to read more :-
https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-create-and-manage-relationshipsHope this was helpful.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos Cpratyashasamal hi thanks for heping, but doesnt solve my issue..
Hi,
This table I will call Problem
Model Name Problem Value A Size 10 B Size 5 C Color 3 E No Issue 2 E Color 1 This table I will call Order.
Model Name Value Qty A 1 100 A 2 30 C 3 1 D 10 3 C 4 2 Create a reference to the Problem table and remove all but the model column.
Create a reference to the Order table and remove all but the model column.
Append the two new referenced tables together.
Remove the duplicates in Model column.
Join the new dimension table table to the two fact tables Order and Product.
You can now slice by model.
A video explaining the process: https://www.youtube.com/watch?v=2iEapc7yE_g
Cheers
John
Hi Thanks for helping, is it possible to slice by problem?
Actually I have lots of model, I would like to create a slicer that slice problem category and show the model/qty/valueHi,
Sorry, I read your requirement incorrectly.
The original poster is partly correct, join both tables on Model. I assume you will have a many to many relationship. This will create a many to many realtionship but that will be ok. Make sure cross filter direction is set to both.
Then create a reference to the Problems table.
Remove all columns except the problem column.
Remove duplicates.Join the new Problem lookup (slicer / dimension) table to the other problem table on Problem. This will be a one-many relation. It will now slice both.
See images
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
