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.