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.

MFelix's avatar
MFelix
Icon for Super User rankSuper User
5 years ago

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's avatar
Anonymous
Not applicable
5 years ago

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

    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.