Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
I have two matrix visuals in Power BI that I want to display together. Each matrix scrolls independently, and the tables behind them do not share a common key. I need a way to combine or join these matrices into one unified view so that they can scroll together or be displayed as a single matrix
Hi @bryanfungurai ,
We wanted to kindly follow up regarding your query. If you need any further assistance, please reach out.
Thank you.
Hi @bryanfungurai ,
Just wanted to check if the responses provided were helpful. If further assistance is needed, please reach out.
Thank you.
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:
Thank you
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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português| User | Count |
|---|---|
| 13 | |
| 9 | |
| 6 | |
| 5 | |
| 5 |