Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Matrix Row Header Alignment

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
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

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

mon's avatar
mon
Frequent Visitor
3 years ago

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's avatar
MFelix
Icon for Super User rankSuper User
3 years ago

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.