The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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êsUser | Count |
---|---|
77 | |
75 | |
36 | |
31 | |
29 |
User | Count |
---|---|
94 | |
80 | |
55 | |
48 | |
48 |