Power BI - How to vertically center align the data.

[Anonymous]

Hello all,

We have a below report to show Product Sales. Our customer wants some of the column should be Vertically centered Align. for Example Product & Product Type column should be vertically centerted align.

How to achieve it..

Thanks,

PBI V2

[analistaribeiro]

Did you ever used UNICHAR(10) to align that?
Let me explain a little more...

If you have a measure titled as "NAME", you can use another measure called "NAME ALIGNED" (or anything you want...) and concatenate with UNICHAR(10) that means "ENTER". Like this:

NAME ALIGNED = UNICHAR(10)  & UNICHAR(10)  & [NAME]

[VijayP · Accepted solution]

@Anonymous  That is not possible in Matrix Visual

[VijayP]

@Anonymous  Try Row Headers Align Center

[Anonymous]

Hello @VijayP 

Thanks for your response

We have checkedand found that Row Header is centered align. so horizontally, it is working fine. We need to vertically centered align. Below is the screenshot showing Text in Red box is actual location and we need text in location mentioned in green box.

Thanks,

PBI V2

[analistaribeiro]

Did you ever used UNICHAR(10) to align that?
Let me explain a little more...

If you have a measure tittled as "NAME", you can use another measure called "NAME ALIGNED" (or anything you want...) and concatenate with UNICHAR(10) that means "ENTER". Like this:

NAME ALIGNED = UNICHAR(10)  & UNICHAR(10)  & [NAME]

See more: UNICHAR function - Microsoft Support
About "UNICODE": List of Unicode characters - Wikipedia