Forum Discussion
ktt777
2 years agoHelper V
Switching row and column in matrix
hi all,
i have a power bi file to calculate the rolling 12 months average per quarter ( with slicer)
Power BI file is Rolling 12 months every quarter.pbix
is there a way to have a table switching row and column as below
thank you.
then you need to format the visuals: Values -> Options -> Switch values to row........
3 Replies
- hxshxmxhrNew Member
switch the placement in rows to columns
- ktt777Helper V
thank you,
that's simple case for 1 measure. if i have 2 measures to be shown in the graph
how can i have the table arranged this way :
Power BI is showing this :
Rolling 12 months every quarter.pbix
thanks,
- hxshxmxhrNew Member
then you need to format the visuals: Values -> Options -> Switch values to row........