Forum Discussion
Lookup not working
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.
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.
Hi Parry,
Than you so much Parry for your suggestions.
My “table 2” has 85 columns and more than million records. I have tried Unpivot Other column and two new columns display very weired dataset.
Do you have any other suggestion?
Thanks
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.
Thank you so much Parry.It is working fine.Thanks