Need help with custom Databar colors based on the % values

Question

Hi Team,&nbsp;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 rules1. Anything 100%=Green2. 90% and above = Amber3. 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.&nbsp;Please helpThank you in advance!

anonymous · Answer

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.&nbsp;If anyone knows a solution, please let me also know!&nbsp;

v-ssriganesh · Answer

Hello Anonymous,Thank you for reaching out to the Microsoft Fabric Forum Community and thanks to Anonymous&nbsp;for the helpful insights.
As mentioned by Anonymous, 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 · Answer

Hi Anonymous,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.

v-ssriganesh · Answer

Hello Anonymous,
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.

Forum Discussion

Need help with custom Databar colors based on the % values

Related content

Table Databars with color coding - custom visual?

Treemap Color Customization

Customize Slicer Button Colors

Dial gauge color customization

Customizing colors doesn't work