remove button colour fill function

[DEngg]

I created a Power BI report in Desktop and used a button with a conditional fill color (based on a formula). But after publishing it to Power BI Fabric, the conditional fill color no longer works or disappears, and I am trying multiple times but get the  same issue

[DEngg]

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 

[v-sgandrathi · Accepted solution]

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.

[v-sgandrathi]

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-sgandrathi]

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!

[v-sgandrathi]

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.

[DEngg]

But we assign the filter buttons as a column, not a measure or any?
so, every time buttons get the value 

[v-sgandrathi]

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!

[DataNinja777]

Hi @DEngg ,

This issue typically happens because conditional formatting on a button’s fill color in Power BI Desktop doesn't always translate properly when published to the Power BI Service (Fabric). The Service often fails to evaluate DAX-based color expressions if the measure you're using doesn't have the right context or returns blank. For example, if your fill color is defined like this:

ButtonColor = IF([Status] = "Active", "#0078D4", "#A80000")

it may work in Desktop where filters and visual context are applied, but fail silently in the Service where the button lacks context. This results in the fill color disappearing or defaulting.

To debug, try wrapping the logic in a COALESCE to force a default color:

ButtonColor = COALESCE(
    IF([Status] = "Active", "#0078D4", "#A80000"),
    "#FFFFFF"
)

If that doesn’t work, replace the button with a shape, which handles conditional formatting more reliably, or test the measure by applying it to a card to confirm it returns a value. The Service can be finicky about visuals like buttons that aren’t tied to a data context, so moving to a shape or card visual with an assigned action often bypasses the issue until Microsoft fixes the bug.

Best regards,

[DEngg]

this problem also occurs within fabric report to edit and save.

We can not use shape because we need to use multiple selection buttons
If we used a shape based on all statuses, we need to use a different page or bookmark