Forum Discussion
remove button colour fill function
- 1 year ago
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,
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 DataNinja777,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
If our response has addressed your query, please accept it as a solution and give a ‘Kudos’ so other members can easily find it. Please let us know if there’s anything else we can do to help.
Thank you.
- v-sgandrathi1 year agoCommunity Support
Hi DEngg,
Hi
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!