Matrix Row Header Alignment

[Anonymous]

Hi,

I want to keep a;ignment for few row headers as Center and for Few row headers as Left.

Couls you please let me know how to achieve this?

Thanks,

Sam

[mon]

Hi Guys,

Is there any formula to change the alignment for few row headers as Center and for Few row headers as Left?

Kindly guide.

Thanks.

[MFelix]

Hi @mon ,

In this case you would need to do the new coluns with the variations you would need something similar to this:

Cat Alignment = 
SWITCH ('Table'[cat] ,
 "A",REPT( UNICHAR(8192),10) & 'Table'[cat], 
"B", 'Table'[cat],
 "C",REPT( UNICHAR(8192),10) & 'Table'[cat])

This would give you different spacings for each value. On the settings you cannot set up a row value at a time.

For columns you have that option since you can setup each of the columns separatly.

[MFelix]

Hi @Anonymous ,

On the matrix options go to Field formatting and then select the alignment apply to header option must be active:

You can format each column individually.

[Anonymous]

@MFelix ,

Thanks, but its only available for columns from 'Value' section. I wanted to modify alignment from 'Row Hedear ' section columns. I think it's not available it in Power bi. Either we can do it same for ALL columns from row header section. It's not giving option toodify it individually.

[MFelix]

Hi @Anonymous ,

You are correct I missread the title, one option can be to create a new column with the following code:

Cat Alignment = IF('Table'[cat] = "A",REPT( UNICHAR(8192),10) & 'Table'[cat], 'Table'[cat])

Has you can see below the A moves forward by 10 spaces:

Giving the sense of center alignment, you can optimize this by change the number of repts by a dinamic number.

[amitchandak · Accepted solution]

@Anonymous , The option I can see in the table is align all columns together not for each one.