Vertical Alignment of Row Headers in Matrix

[Gautam_Yadav]

Hi Everyone
I have attached a photo below

I want the Category [Row Header] To be Vertically Alligned At Centre 
I tried the below Calculated Column 

Padded Row Header = REPT(UNICHAR(10), 195) & 'CategorySource'[Category]


It dosent work , are there any work arounds?

[danextian]

Hi @Gautam_Yadav 

This would be a very difficult thing to do even with dynamic lenght of left and right pad characters as each character in the text string can have a varying width (1 and i very narrow while W is very wide).

Centered Subcategory = 
VAR _PadChar =UNICHAR(8199) // choose any character you want, e.g. " ", "-", "*", etc.
VAR _Sub = [Subcategory]
VAR _MaxLen =
    MAXX ( ALL ( 'Table' ), LEN ( 'Table'[Subcategory] ) )
VAR _CurLen = LEN ( _Sub )
VAR _TotalPad = _MaxLen - _CurLen
VAR _LeftPad = INT ( _TotalPad / 2 )
VAR _RightPad = _TotalPad - _LeftPad
VAR _result = 
    REPT ( _PadChar, _LeftPad ) & _Sub & REPT ( _PadChar, _RightPad )
return
_result

Here's a sample calculated column. You can see that it doesn't visually perfectly align the texts

[Gautam_Yadav · Accepted solution]

Got it thanks for the reply.

As of now Since there are no constant Visual Changes I just added a Text Box Above Them and Aligned as needed.

[v-tejrama]

Hi @Gautam_Yadav ,

Thank you for your response. Can you confirm whether adding the text box resolved your issue, or if the workaround provided by the @danextian  was the solution? Your feedback will enable us to close the loop effectively and offer clear guidance to others who encounter similar situations.

Thank you,

Tejaswi.

[Gautam_Yadav]

The text box resolved my Issue.

[v-tejrama]

Hi @Gautam_Yadav ,

I'm glad you found a solution and resloved  the query. Thank you very much for sharing here.

If you have further queries please reach out.

Thankyou for connecting with Microsoft Community Forum.

[GeraldGEmerick]

@Gautam_Yadav Perhaps: 

Padded Row Header = REPT(UNICHAR(10) & UNICHAR(13), 195) & 'CategorySource'[Category]

[Gautam_Yadav]

Hi @GeraldGEmerick  Thanks for the reply.
I tried your solution the Row Headers are Still at Top Left and not bulging. 

[GeraldGEmerick]

@Gautam_Yadav Perhaps try increasing your Grid padding. I'm still not clear on how your matrix is configured to understand your setup. Can you share additional details? Like what columns are in which fields, etc.

[Gautam_Yadav]

Sharing Above my fields
I already have enough padding Sharing below settigns

[GeraldGEmerick]

@Gautam_Yadav In looking at this some more, doesn't look possible. The reason is that it looks like perhaps you are using the Compact layout and you have turned off row banding for Row Headers. If you turn that back on, you will see that the value only appears in the first row. Therefore, even if you managed to put verticle whitespace around that value, all it would do is expand the height of that one row and push all the other rows down which is not what you want to achieve. 

[Gautam_Yadav]

It would be greatly appreciated if you could share a PBI file where you have implemented this. I will attempt to replicate the process on my end.

[Gautam_Yadav]

I am using the Default,Outline.