Forum Discussion
undefined
- 5 months ago
Power BI does not support synchronized scrolling between two separate matrix visuals. Each one will scroll independently. If the goal is one single matrix then you need to reshape the data first.
If the two datasets are completely unrelated but you still want them shown in one visual, you can create a disconnected helper table that defines the row labels you want, then use measures to return values for each section.
Typical pattern:
- create a layout table with rows like Metric A, Metric B, Metric C
- create measures that return values from table 1 or table 2 depending on the selected row
Hi bryanfungurai ,
Taking into consideration what you refer it's going to be tricly to combine them, I assume that you have different rows but also different columns for each matrix, this would lead to an imense code or a combination of values in order to get everything in the same matrix.
Have you tough about changing the user experience? Instead of doing a scroll matrix doing a paginated matrix? this could lead to a more easier way to present results in both of them.
Check the video below:
This is for a chart but can work with matrix also.