How to add a measure to a row

[yoshi_matsu]

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/01	2024/01/02	2024/01/03	2024/01/04
majorA	XXXX	XXXX	XXXX	XXXX
majorB	XXXX	XXXX	XXXX	XXXX
majorC	XXXX	XXXX	XXXX	XXXX
majorD	XXXX	XXXX	XXXX	XXXX

[MattAllington · Accepted solution]

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

[Thejeswar · Accepted solution]

@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

[yoshi_matsu · Accepted solution]

Thank you !!

[Thejeswar · Accepted solution]

@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

[MattAllington · Accepted solution]

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

[yoshi_matsu]

Thank you!!