Forum Discussion
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
Anonymous , The option I can see in the table is align all columns together not for each one.
6 Replies
Anonymous , The option I can see in the table is align all columns together not for each one.
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.
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.
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.
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.
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.
