Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

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

View solution in original post

6 REPLIES 6
mon
Frequent Visitor

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.


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



MFelix
Super User
Super User

Hi @Anonymous ,

 

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

 

MFelix_0-1619015928326.png

You can format each column individually.

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Anonymous
Not applicable

@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:
MFelix_0-1619519686179.png

 

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

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



amitchandak
Super User
Super User

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

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors