Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Need help with custom Databar colors based on the % values

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 = A...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
v-ssriganesh's avatar
v-ssriganesh
Icon for Community Support rankCommunity Support
1 year ago

Hello Anonymous,
Thank you for reaching out to the Microsoft Fabric Forum Community and thanks to Anonymous 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's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support
    1 year ago

    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.