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,

We’re following up once again regarding your query.

As previously mentioned, the feature you’re looking for is currently not available, and we had suggested submitting it to the Ideas Forum for consideration in future updates.

Since there has been no further response, we will go ahead and close this thread.

If you have any new questions or need further assistance, please feel free to create a new thread. We’ll be glad to help.

Thank you for your understanding and continued participation in the community.

[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.

[v-ssriganesh]

Hi @abhishek_2593,
I hope the information provided has been useful. Please let me know if you need further clarification or would like to continue the discussion.
If your question has been answered, please “Accept as Solution” and Give “Kudos” so others with similar issues can easily find the resolution.
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!