Need help with custom Databar colors based on the % values

[abhishek_2593]

Hi Team,

I have a table from which i am calculating and using average % in matrix visual and want to color code the databars based on the below rules
1. Anything 100%=Green
2. 90% and above = Amber
3. 90% and below = Red.

How can i achieve this using Data bars as i want the % fill as per the % value but the color coding as per the above condition.

Please help
Thank you in advance!

[v-ssriganesh]

Hello @abhishek_2593,
Thank you for reaching out to the Microsoft Fabric Forum Community and thanks to @bnjmnnl for the helpful insights.

As mentioned by @bnjmnnl, Power BI currently does not support dynamic color formatting for data bars in matrix visuals using DAX logic. You can format background or font colors conditionally, but not the color of data bars themselves.

If this is a key feature for your reporting needs, we encourage you to submit it as an idea in the Microsoft Fabric Ideas forum: Submit an Idea – Microsoft Fabric Ideas

If your idea receives enough community support (votes), it will be considered by the product team for a future release.

If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[bnjmnnl]

Hello!
As far as I know, this is not possible in such way you can adjust background colors. Pleas submit this idea, would be helpful and kind off logical to have this with progres bars. I would suggest to have the column on the left color your requested way, or placing a bar chart with the coloring on the right side. 
If anyone knows a solution, please let me also know!