Forum Discussion
How to merge multiple matrixes into 1?
Hello everyone! I ran into a pickle for my report. I would like to create a visual in my report like so:
| Date | January | February | March | April | May |
| Visits | 50 | 250 | 350 | 275 | 550 |
| Conversion | 75% | 65% | 45% | 55% | 57% |
| Control Conversion | 48% | 42% | 65% | 25% | 33% |
| Revenue | $100 | $500 | $650 | $550 | $750 |
I have Data in multiple queries in my report:
One is a DateDim
One is Visit Trends
The other is Conversion for both Control and Actual
The other is a Revenue query
I would like a visual I can create identical to the template I put above, but I am facing issues.
If I try a Matrix, the Month is going to be great as the Column, but if I put in multiple values, I am facing an issue with me putting in rows to break down those values and I break up using multiple matrixes to make it show vertically (See below)
If I try a table, it works great, however the structure of my template is flipped and goes vertically rather than horizontally (see below). Is there a way I can flip it or a better visual to use to help replicate my template?
1 Reply
- MFelix
Super User
Hi Anonymous ,
Add the measures you need to your matrix then on the options search for the show in rows and your values will be presented in the rows:
https://www.selectdistinct.co.uk/2023/02/27/show-values-in-rows-in-power-bi/
