Forum Discussion
GowthamK66
1 year agoFrequent Visitor
How to create this table(Transpose)
Expectation: all the table measures will be in row-wise below the metrics column, so how we can do this the data source is in the SSMS server L4 is Last four week, L13,L26,L52 Should come as each co...
- Anonymous1 year ago
Hi GowthamK66
Please try this:Here I have the sample data:
You can create a matrix and put the category column on the Columns box:
And open the Switch values in row groups rather that columns:
The result is as follow:
And here's another workaround:
Add a new table:
Table 2 = {"Measure1","Measure2","Measure3"}Then add a new measure:
Measure = VAR _Values = SELECTEDVALUE('Table 2'[Value]) RETURN SWITCH( _Values, "Measure1",[Measure1], "Measure2",[Measure2], "Measure3",[Measure3] )Finally, create a matrix with these fields:
The result is as follow:
Best Regards
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
GowthamK66
1 year agoFrequent Visitor
The thing is all the measures should be placed in the Row level but in Power BI we can't do that, we can place the measure only in Values not in Rows😥