Forum Discussion

ktt777's avatar
ktt777
Icon for Helper V rankHelper V
2 years ago
Solved

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 s...
Need Help
  • hxshxmxhr's avatar
    hxshxmxhr
    2 years ago

    then you need to format the visuals: Values -> Options -> Switch values to row........

     

ktt777's avatar
ktt777
Icon for Helper V rankHelper V
2 years ago

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,

  • hxshxmxhr's avatar
    hxshxmxhr
    New Member
    2 years ago

    then you need to format the visuals: Values -> Options -> Switch values to row........