Forum Discussion

yoshi_matsu's avatar
yoshi_matsu
Frequent Visitor
2 years ago
Solved

How to add a measure to a row

I wanted to arrange the measures along the columns and the years and months along the rows because there are so many measures, but I found that it's not possible to add measures to rows due to Power BI's specifications. Does my approach contradict any fundamental principles of Power BI?

I am trying to create a table that shows the number of cases at each step of the business acquisition process for each month, based on an SCD2 model.

 

 2024/01/012024/01/022024/01/032024/01/04
majorAXXXXXXXXXXXXXXXX
majorBXXXXXXXXXXXXXXXX
majorCXXXXXXXXXXXXXXXX
majorDXXXXXXXXXXXXXXXX

 

Need Help
  • Thejeswar's avatar
    Thejeswar
    2 years ago

    yoshi_matsu ,

    You can use marix visual to get the visual you are expecting to see.

     

    Place the column that has values for Major in x-axis, while the data column should be kept in Y-axis. you can place the measures in the value section of the matrix.

     

    You can make the measures as rows using the "Switch values to rows" option in the value section. For reference, ss given below

     

4 Replies

  • MattAllington's avatar
    MattAllington
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Nope. Use a matrix and select "measures on rows". You can search for it

  • Thejeswar's avatar
    Thejeswar
    Icon for Super User rankSuper User
    2 years ago

    yoshi_matsu ,

    You can use marix visual to get the visual you are expecting to see.

     

    Place the column that has values for Major in x-axis, while the data column should be kept in Y-axis. you can place the measures in the value section of the matrix.

     

    You can make the measures as rows using the "Switch values to rows" option in the value section. For reference, ss given below