Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Power BI - How to vertically center align the data.

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 ...
Need Help
  • VijayP's avatar
    VijayP
    2 years ago

    Anonymous  That is not possible in Matrix Visual

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

 

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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