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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
bmyton
Frequent Visitor

Formatting Specific Column in Service - Duplicate Names

Hi BI Team,

 

I may need to report this somewhere else, but if a table has multiple columns with the same name (bad practice), the format pane struggles to format one versus the other.

 

In this example, there are two "Days" columns, selecting etiher one will result in only formatting the first one.

 

Adding a blank space to the end of the second "Days " will let you format it separately.

 

bmyton_0-1672333122759.png

 

1 ACCEPTED SOLUTION
v-xiaosun-msft
Community Support
Community Support

Hi @bmyton ,

 

Unfortunately, the current version of Power BI Desktop doesn't support creating columns with the same names.

vxiaosunmsft_0-1672379790526.png

When you add spaces to the end of one column name, it will be identified another column. And you can only apply format to one column at one time.

vxiaosunmsft_1-1672379854069.png

 

You can submit it to an idea or ticket it.

Ideas (powerbi.com)

 

Best Regards,
Community Support Team _ xiaosun

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

1 REPLY 1
v-xiaosun-msft
Community Support
Community Support

Hi @bmyton ,

 

Unfortunately, the current version of Power BI Desktop doesn't support creating columns with the same names.

vxiaosunmsft_0-1672379790526.png

When you add spaces to the end of one column name, it will be identified another column. And you can only apply format to one column at one time.

vxiaosunmsft_1-1672379854069.png

 

You can submit it to an idea or ticket it.

Ideas (powerbi.com)

 

Best Regards,
Community Support Team _ xiaosun

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.