Forum Discussion
Show Benchmark Data from Separate Table
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.
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.
2 Replies
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.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
