Forum Discussion
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 2 2 2
I have a visual based on the above table. I have one more table
Table 2
Group Process
ABC Process1
ABC Process2
XYZ Process3
XYZ Process4
I would like to set a filter on table 2 - group , so if the user clicks ABC only the process 1 and Process 2 shows up in the Visual.
How do i make this happen? currently i am struggling - would i do this in EXCEL and import a new table or change in powerbi query..if you could explain the logical steps then if i click the ABC in the filter pane the visual updates to show only the process 1 and process 2 columns.
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
3 Replies
venkik79 , 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/500115Could you please explain the steps in how i go about doing it.
I don't want to change anything in Table 1 - its the main table where i am plotting a BI visual.
for Table 2 should i import and create a relation ship - if yes any article or if you could write generic logic steps then i can pick it from there.
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
