Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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?
Hi @PrivateAnalytic ,
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/
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsMarch 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
144 | |
73 | |
64 | |
52 | |
51 |
User | Count |
---|---|
208 | |
91 | |
62 | |
59 | |
56 |