Forum Discussion
Solved
Visual Filter based on data from a different table - Need help GURUS
Hello Table 1 Name Process1 Process2 Process3 Process4 joe1 1 3 2 4 Joe2 0 2 4 2 joe3 3 ...
Hi venkik79 ,
You will need to unpivot table1 in Query Editor.
Select the Name column and use unpivot other columns feature.
Create a martix using Name as rows, Attribute as columns and Value as values.
Then the slicer should work.
Best Regards,
Jay
amitchandak
Super User
Super Uservenkik79 , better to unpivot the first table and create a common dimension.
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Else try something very similar to
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115