Visual Filter based on data from a different table - Need help GURUS

[venkik79]

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.

[amitchandak]

@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-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[venkik79]

@amitchandak 

Could 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.

[v-jayw-msft · Accepted solution]

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