Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

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 identifierTest 1 resultTest 2 result
1X1052
2A2561
3A2360
4X1254

Table 1: Test Results Data

 

Part identifierTest 1 Lower spec limitTest 1 upper spec limitTest 2 lower spec limitTest 2 upper spec limit
A20255565
X10155055

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!

Need Help

1 Reply

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion
    4 years ago

    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