Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
@Anonymous , The option I can see in the table is align all columns together not for each one.
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
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @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.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@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:
Giving the sense of center alignment, you can optimize this by change the number of repts by a dinamic number.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em Português@Anonymous , The option I can see in the table is align all columns together not for each one.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |