Show table visual vertically instead of horizontally

[Anonymous]

Hello All,

I'm using the Table Visual in my report to show a variety of measures or kpi's as we all often do.  The table visual always goes left to right meaning you put in one field and it shows the value right under it, you add in another field and it goes to the right of the first one with its value underneath it, etc. etc.  Instead of having this go left to right, I have a need for it to go top/down.  So in this instance it would be one Field with its value to the right, then another field put directly under the first with its value to right as well, etc. etc.  I'm just trying to switch the orientation of the table visual from going horizontally to vertically - is this possible?  I do not see a setting that will allow me to do this.  Or can someone recommend a custom visual that could do this?

Thanks,

YB

[v-yingjl]

Hi @Anonymous ,

You can try to use Matrix visual instead of Table visual.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[TomMartens · Accepted solution]

Hey @Anonymous ,

you can't use the table visual, instead use the matrix visual.

Then activate the "Show on rows" property, this setting allows to transform this

into this

Hopefully, this is what you are looking for.

Regards,

Tom

Stay safe, stay healthy, and happy holidays

[sshah2]

I don't have this option in power BI! How can I get it?