Forum Discussion
Solved
Transpose table with weighted average
Hello Guys, Can you please help me with transposing table? I need to create P&L per specific category. My problem is that Category is in rows but I need that in columns. Please be aware that c...
Hi,
I tried but i can't any way to get table like which u mention in above.
but i suggested to u, y u go with like this model. it will also help to u reach your goal.
pls look these images , and let me know if any help.
Select four column and click Unpivot
Now this is your Table
This is Matrix Report
Here you find a nifty workaround for your request: http://exceleratorbi.com.au/measures-on-rows-here-is-how-i-did-it/
... and of course: Pls vote for this to become a standard-feature here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/10948962-matrix-measures-or-values-on-rows-instead-of-colum
Hello ImkeF. Thank you for your sugestion. I will look at this once I will be back from my holiday.
