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 = 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!

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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! 

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

  • v-ssriganesh's avatar
    v-ssriganesh
    Icon for Community Support rankCommunity Support
    1 year ago

    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.