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 v-sgandrathi DataNinja777
Thank you for replying and understanding the problem
In my case, we display the machine data with their status, like online, offline, and unknown These three cases.
requirement (we need to use the filter button to filter the visual also we can select multiple buttons)
Now this all filter we used condition fill colour like online=green,offline=red,unknown=grey
So we need to require colors on the button that can't be used by default
On the data side,we assign filter to as a column, these three status values are an actual column, not a measure
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.
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!