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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
mahenkj2
Solution Sage
Solution Sage

How to change border color of bars of a colustered column chart

Hi,

I have created a colustered column chart and each column represent differet color based on that field value. I have set it up with the help of conditional formatting.

The problem is while bar is inivsible due to white background, so I want to make border of these bars of black or some other color visible on white background.

mahenkj2_0-1627345543498.png

 

Is color of border of these bars controllable. I in fact could not find any solution.

 

Thanks.

1 ACCEPTED SOLUTION
samdthompson
Memorable Member
Memorable Member

no, the colour of the borders is not controllable. Perhaps it is if you use one of the third party charts but that seems a bit more difficult than changing the conditional formatting to something not white.

 

 

// if this is a solution please mark as such. Kudos always appreciated.

View solution in original post

6 REPLIES 6
BPguy
Regular Visitor

I can't believe 2 years have gone by and this still isn't possible. It's been in Excel for a very long time.

BPguy_0-1695328767236.png

 

Power BI team has a lot on their plate. Of all the demands out there, minor formatting improvements to existing visuals will likely be pending for a long time.

 

There are custom visuals on Appsource that can solve your problem.

This is one example - 
https://appsource.microsoft.com/en-us/product/power-bi-visuals/clusteredstackedcolumnpro

 

pbivizedit clustered column chart with borderpbivizedit clustered column chart with border

 

 

v-jingzhang
Community Support
Community Support

Hi @mahenkj2 

 

It's not supported to change the border color of bars currently, maybe you can consider change the background color to some color out of range of all bar colors to make white bar more visible. 

 

Another option is to use other white colors to represent white. For example, you can create a measure like below and select it for conditional formatting. It colors white bar with "#FAF9F6". This will make it a little different from the background. White Color CodesShades of White

Color Measure =
SWITCH (
    SELECTEDVALUE ( 'Table'[Color] ),
    "White", "#FAF9F6",
    SELECTEDVALUE ( 'Table'[Color] )
)

072901.jpg

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

mahenkj2
Solution Sage
Solution Sage

I have submitted an idea relating this problem, if the community likes this idea and think that it can solve above problem, please upvote.

https://ideas.powerbi.com/ideas/idea/?ideaid=f36b3604-86ee-eb11-ba5e-501ac50a6edb 

samdthompson
Memorable Member
Memorable Member

no, the colour of the borders is not controllable. Perhaps it is if you use one of the third party charts but that seems a bit more difficult than changing the conditional formatting to something not white.

 

 

// if this is a solution please mark as such. Kudos always appreciated.

Oh thanks, but that's a basic feature, generally available for known charting softwares.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.