Forum Discussion
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 centerted align.
How to achieve it..
Thanks,
PBI V2
Anonymous That is not possible in Matrix Visual
5 Replies
- VijayP
Community Champion
Anonymous Try Row Headers Align Center
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
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
- VijayP
Anonymous That is not possible in Matrix Visual
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]