Forum Discussion
Lookup not working
Hello Community,
Please see below my dataset,I have tried lookup no luck.Can anyone suggest me ?
Table 1 | |
Name | Match Column |
GM | GM DISCOUNT |
VP | VP DISCOUNT |
SALES | Sales DISCOUNT |
Table 2 | |||
Product | GM DISCOUNT | VP DISCOUNT | Sales DISCOUNT |
A | 50% | 40% | 15% |
B | 60% | 30% | 10% |
C | 70% | 20% | 5% |
When user select Product using SLICER VISULIZAITON it should display below result,
PRODUCT SLICER=”A”
Final Result | |
Name | Discount |
GM | 50% |
VP | 40% |
SALES | 15% |
Anonymous interesting, ofcourse without knowing that you so many columns I suggested the solution. One solution might be to make copy of your original table and remove all the other column and keep the column you are interested and then use that for unpivot and make visual from new table.
4 Replies
- parry2k
Super User
Anonymous You need to unpviot your table2. Select Productcolumn in Power Query and right click and chose 'unpivot other columns', it will add two columns "attribute" and "value", rename attribute to "Name" and value to "Discount".
Now if you slicer by product, you will see respective records.
- parry2k
Anonymous interesting, ofcourse without knowing that you so many columns I suggested the solution. One solution might be to make copy of your original table and remove all the other column and keep the column you are interested and then use that for unpivot and make visual from new table.