Merging of two tables and scrolling the tables equally

[karthickcourse5]

I have 2 tables (Table 1 & Table 2). Client needs to compare the products from two tables.

In 'desired output'' , there are 3 tables :

Table 1: Metric, Header, KPI, Classification, Banner 1 & 2 from Table 1/data source 1

Table 2: Products from Table 1/data source 1

Table 3: Products from Table 2/data source 2

Challenges:

1) I can't scroll all the tables (1, 2 & 3) together

2) While filtering the products to compare, the selected product should only display in one table while the other table should shows the rest of the product along with the conditional formatting

3) If 2nd option is not possible it is better to show the selected and other products in one table, same for second table 

FYR, I have tried the matrix, reason not using it is because of the two product comparison. 

Please view the above image for more information.

Looking for your valuable support. Thanks in advance.

[v-lili6-msft · Accepted solution]

hi @karthickcourse5 

1. It is not supported to implement your demand that scroll all the tables (1, 2 & 3) together in Power BI currently.

2&3. First, you should use dim table to create the relationship between these two tables, however, It doesn't support highlight for table and matrix visual in power bi for now.

https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions

Regards,

Lin

[karthickcourse5]

Thanks for your time.