Forum Discussion
Helper VWant to show data from two tables
Hi,
I have two tables as follows:
Table-1:
CATEGORY ID SALES
| A | 101 | 150 |
| B | 102 | 230 |
| C | 103 | 400 |
| D | 104 | 780 |
| A | 105 | 300 |
| B | 106 | 200 |
| C | 107 | 100 |
| D | 108 | 150 |
| E | 109 | 200 |
| F | 110 | 200 |
TABLE-2:
CATEGORY ID VALUE
| A | 101 | 100 |
| B | 102 | 200 |
| C | 103 | 300 |
| D | 104 | 290 |
| E | 105 | 400 |
| A | 106 | 200 |
| B | 107 | 100 |
| C | 108 | 150 |
| D | 109 | 100 |
Now I need to add Category and ID to slicers, based on slicer selction want to show data but the result is not showing as required
Please help me to do.
Thanks,
AshDil
11 Replies
- Pragati11
Super User
HI AshDil ,
I think your many-to-many relationship might be working weirdly.
Try intriducing a bridge table between your two tables and create a many-to-one or one-to-many relationship of these 2 tables with this bridge table.
Bridge table will be a table having distinct values of the column that is currently used to create a relationship between your tables.
Check an existing thread on creating bridge table: https://community.powerbi.com/t5/Desktop/Bridge-Table-to-bypass-Many-to-Many-Problem/m-p/943389
Thanks,
Pragati
- Greg_Deckler
Community Champion
AshDil You need to create a relationship between the tables.
AshDilHi Greg_Deckler ,
I have tried creating relationship between both tables, both having many to many relationship so the values are duplicating because of it.
And I tried creating dimtable having column Category and ID, again relationship between dimtable and table-1 is many:many an also between dimtable and table-2 is many:may.
Thansk,
AshDil
