Forum Discussion
How to create this table(Transpose)
- 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.
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.