Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
karthickcourse5
Frequent Visitor

Merging of two tables and scrolling the tables equally

Merging Two Tables.png

 

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.

1 ACCEPTED SOLUTION
v-lili6-msft
Community Support
Community Support

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

 

 

 

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

View solution in original post

2 REPLIES 2
v-lili6-msft
Community Support
Community Support

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

 

 

 

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

Thanks for your time.

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.