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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.