Forum Discussion
Visualize filtered horizontal data vertical
Dear PBI colleagues
I can't find the way to do the following
Want to from horizontal table get a vertical report (list of data) for filtered column (Name)
It should look similar like
The point is not to lose Source table because I need it for calculations (measures)
Actually it will be kind of catalogue of the names – when I chose name I will get the rest of data in vertical table.
gvlado , In a matrix visual put # on the column, No row, and put name, location, size, group, etc as a measure
and then use option - Switch values to row /Show values on row
2 Replies
gvlado , In a matrix visual put # on the column, No row, and put name, location, size, group, etc as a measure
and then use option - Switch values to row /Show values on row
Wow, what a simple solution
Now I recognized Switch in options
Thanks a lot - you earned a coffee
