Forum Discussion

Frequent Visitor

6 years ago

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

Data Protection

Anonymous
5 years ago
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

Frequent Visitor

6 years ago

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.

Anonymous

Not applicable

5 years ago

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