cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

column headers alignment based on column data

I would like to apply different alignments to columns within the same table. Table design best practices dictate that column headers should be aligned to match the data in the column so that the eye can easily scan down the column. And since as power BI knows, text should be aligned left while numbers are best aligned right, we should be able to match the alignment of the header to the alignment of the data in said column. Is this on the cards horizon for future improvement? 

 

Good article on table design for those interested in learning more: 

https://medium.com/mission-log/design-better-data-tables-430a30a00d8c

 

Thanks!

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Super User III
Super User III

Re: Column header names alignment to match column data

Hi @coop0987,

 

Believe this postis duplicated with the one below_:

 

http://community.powerbi.com/t5/Desktop/column-headers-alignment-based-on-column-data/m-p/406152/hig...

 

I have posted an answer or the previous one  please check it and delete this post if duplicated.

 

Regards,

MFelix


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





View solution in original post

Highlighted
Resident Rockstar
Resident Rockstar

Re: column headers alignment based on column data

Hi @coop0987

 

The answer of @MFelix should be the solution, if you have solved the problem, please accept his answer as a solution so that people who may have the same question can get the solution directly.

 

If that is not the answer, please show your expected output, so that we can help further investigate on it?

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

7 REPLIES 7
Highlighted
Regular Visitor

Column header names alignment to match column data

I would like to apply different alignments to columns within the same table. Table design best practices dictate that column headers should be aligned to match the data in the column so that the eye can easily scan down the column. And since as power BI knows, text should be aligned left while numbers are best aligned right, we should be able to match the alignment of the header to the alignment of the data in said column. Is this on the cards horizon for future improvement? 

 

Good article on table design for those interested in learning more: 

https://medium.com/mission-log/design-better-data-tables-430a30a00d8c

 

Thanks!

Highlighted
Super User III
Super User III

Re: column headers alignment based on column data

Hi @coop0987,

 

You can on the table or matrix defined column by column a format style on the formatting option you have tree additional settings: apply to header, apply to values and apply to total if you click on all three of them you will  get all the column with the alignment you select:

 

tableformat.gif

 

Regards,

MFelix


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





Highlighted
Super User III
Super User III

Re: Column header names alignment to match column data

Hi @coop0987,

 

Believe this postis duplicated with the one below_:

 

http://community.powerbi.com/t5/Desktop/column-headers-alignment-based-on-column-data/m-p/406152/hig...

 

I have posted an answer or the previous one  please check it and delete this post if duplicated.

 

Regards,

MFelix


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





View solution in original post

Highlighted
Resident Rockstar
Resident Rockstar

Re: column headers alignment based on column data

Hi @coop0987

 

The answer of @MFelix should be the solution, if you have solved the problem, please accept his answer as a solution so that people who may have the same question can get the solution directly.

 

If that is not the answer, please show your expected output, so that we can help further investigate on it?

 

Best Regards,

Cherry

Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
Regular Visitor

Re: Column header names alignment to match column data

Yes this is great news! Thank you!!

Highlighted
Regular Visitor

Re: column headers alignment based on column data

This in in my opinion NOT a good solution. For every table/matrix you have to make 3 adjustments for every column in the Field Formatting subsection of Format:

  • choose the column
  • set alignment for every column - Auto doesn't work
  • Turn on Apply to header

A proper solution would be to add the following an on/off option in the in the  Column headers section
Align all column headers to match column Alignment

Highlighted
Super User III
Super User III

Re: column headers alignment based on column data

Hi @poulj ,

 

On the columns headers there is an option to make it transversal to all the columns however this is not based on the column format.

 

Don't know why this is not based on an automatic format as you refer but is the option so if you want to have different format headers in the tables/matrix visuals you need to follow the refered steps.

 

You can submit an idea on the specifi forum part for this feature if you believe is necessary.

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

Regards,

MFelix

 


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





Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Power Platform 2020 release wave 2 plan

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors