Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi
I am trying to create a report where I have multiple measures to be shown as below
Jan | Feb | MOM Comparison | |
Gross Volume | 5353328.352 | 4550329.099 | 802999.2528 |
Net Volume | 4014996.264 | 3211997.011 | 802999.2528 |
Sales Local | 14327160.52 | 12178086.44 | 2149074.078 |
Sales Export | 0 | 0 | 0 |
Gross Sales | 14327160.52 | 12178086.44 | 2149074.078 |
Returns | 3254 | 1854 | 1400 |
Promotion | 76233.844 | 64798.7674 | 11435.0766 |
Trade Deals | 224492 | 190818.2 | 33673.8 |
Trade Deals on Return | 0 | 2584.2 | -2584.2 |
Trade Promo/Discount/Deals | 300725.844 | 255616.9674 | 45108.8766 |
Near Expiry Discount | 230511.544 | 195934.8124 | 34576.7316 |
Rebates/Listing/BD | 463949.368 | 394356.9628 | 69592.4052 |
Net Sales | 13632699.61 | 11587794.67 | 2044904.941 |
Here all my row headers are separate measures. On columns these can be months or YTD or MOM comparison
Regards,
Affan
Solved! Go to Solution.
Hi,
Click on the Format icon and under the Values section, swithch "On" the Show on rows option.
Hope this helps.
Hi,
Share some dource data.
Hi
Attached is a sample data source I am using for understanding purpose.
My initial requirement is to see the measures as row heders
As of now I can create a visual where I have the Years on rows and measures on columns. But my need is something to transpose it.
Year | 2013 | 2011 | 2012 |
GrossSalesQty | 13778083 | 11851928 | 11270399 |
NetSalesAmount | $2,487,236,058.13 | $3,058,401,994.15 | $2,571,729,210.95 |
GrossSales | $2,554,417,855.67 | $3,144,393,292.13 | $2,642,413,217.03 |
Regards
Affan
Hi,
Click on the Format icon and under the Values section, swithch "On" the Show on rows option.
Hope this helps.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
101 | |
98 | |
98 | |
38 | |
37 |
User | Count |
---|---|
152 | |
121 | |
73 | |
71 | |
63 |