Show Benchmark Data from Separate Table

[SarneyB]

I currently have two seperate tables of data, one which contains information on a number of products, and a seperate table that has benchmark data related to the products. What I am hoping to achieve is to include performance information from both the product and the benchmark in the same table by applying a filter to the product name.

To demonstrate I have created a simplified version of the tables that I am using below in excel

Table 1 - Product Table

Table 2 - Benchmark Table

The desired outcome is that if a slicer was applied to the report on 'Product Name' then if Product 1 was selected, the table of performance would look something like the below:

I am not sure if this is even possible in Power BI, so any help at all would be much appreciated.

[v-yalanwu-msft · Accepted solution]

Hi, @SarneyB ;

You could append two tables in power query.
1.merge table1 to table1.

2.append it.

3. if we select slicer product 1. the final show:

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@SarneyB , Unpivot Year % column in both tables. And then create common dimensions Benchmark and year.

Then you can create measures product1, benchmark 1, and display them on a matrix using Switch on row and year on column