Forum Discussion
remove button colour fill function
Hi DEngg,
Thanks for using Microsoft Fabric Community Forum.
Even though you're using a column for the button values (such as Online, Offline, and Unknown) and not a measure, the issue with conditional fill colour still occurs because Power BI buttons, especially in the Power BI Service (Fabric) -- do not always retain the proper evaluation context needed for conditional formatting. This means that even if the data comes from a column, the button may not be able to determine which specific value is selected when the report loads or when multiple selections are made. As a result, the fill colour condition either doesn’t apply or defaults to blank. Since you're using multi-selection buttons to filter visuals based on machine status, replacing them with shapes is not ideal due to the lack of interactivity and added complexity with bookmarks. A more reliable approach would be to base the button design on a fixed reference table that includes both the status values and their associated colours. This helps maintain context and ensures that the fill colours work consistently across both Desktop and the Service. Until Microsoft resolves this inconsistency in the Service, this workaround offers the best balance between functionality and appearance.
I hope my suggestions provided valuable insights. If you have any further questions, don’t hesitate to ask in a follow-up message.
If this post helped, please mark it as "Accept as Solution" so others can benefit as well.Best regards,
Sahasra.
Hi DEngg,
Thank you for reaching out! The Microsoft Fabric Community is here to help.
Thank you DataNinja777 for the detailed explanation, You’re right.
Conditional formatting on button fills often fails in Power BI Service because the button doesn’t always have the right data context, causing the DAX expression to return blank. Using COALESCE to set a default color is a good way to avoid blanks.
As you suggested, replacing the button with a shape is a practical workaround since shapes handle conditional formatting more reliably online.
We recommend trying them to resolve the issue until an official fix is released.
If my response was helpful, consider clicking "Accept as Solution" and give us "Kudos" so that other community members can find it easily. Let me know if you need any more assistance!
Thank you,
Sahasra
Community Support Team.
Hi DEngg,
We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.
If my answer resolved your query, please mark it as "Accept Answer" and give Kudos if it was helpful.
If you need any further assistance, feel free to reach out.
Thank you for being a valued member of the Microsoft Fabric Community Forum!