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 screenshot is from power bi Visuals, I do not have a physical table like that