How to filter colums used in a single visualization based on column header of a different table

[Anonymous]

Hi,

Thanks in advance to anyone that can try to help! I am trying to create a visualization to monitor test data trends across multiple part numbers, and I am running into an issue with using a single visualization to do so. Im wondering if it is possible and if so how to do the following:

I have two tables of data with examples from each given below:

Index	Part identifier	Test 1 result	Test 2 result
1	X	10	52
2	A	25	61
3	A	23	60
4	X	12	54

Table 1: Test Results Data

Part identifier	Test 1 Lower spec limit	Test 1 upper spec limit	Test 2 lower spec limit	Test 2 upper spec limit
A	20	25	55	65
X	10	15	50	55

Table 2: Specifications

So, I have all of the test result and test spec limit columns selected in the line chart as values, and used the index colum as the X axis, and the part identifier as the drill-through filter. But I want to be able to filter by part identifier and by test name. Right now I can filter by part identifier, but I still see seven tests worth of data that do not necessarily correlate to each other which makes it difficult to read.

Thanks again!

[TheoC]

Hi @Anonymous 

If you go into Power Query (via Transform Data), select all columns other than Part Identifier in your Table 2.  Once you have highlighted all of them, right click a column and click Unpivot Columns.

This should allow you to have all of your records in an order that can be used for filtering. Obviously, change column titles etc as needed.

All the best 🙂

Theo