Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Post Patron
Post Patron

Fill button colour based on field value



I have to show Equipment's current status by 3 different colours, using button, based on current status field's value:


EquipmentCurrent Status
Amp3Prolonged Anomaly
Amp4 Anomaly
Amp5 Healthy
Amp6 Healthy


The colours would be like: Green colour for Healthy, Red colour for Anomaly and Yellow colour for Prolonged Anomaly.

I will use a button for each equipment and fill colour based on the current status.




Community Support
Community Support

Hi, @jitpbi 


You may create a measure like below and make 'Equipment' column conditional formatting based on the measure.

Measure = 
    SELECTEDVALUE('Table'[Current Status]),
    "Prolonged Anomaly","Yellow"




You may create buttons for each equipment and then create a bookmark for each button's  action setting. You can decide which report element to display and which filters to be applied in the bookmark.



Finally you may set the action setting for specific button as below.



When you create a bookmark, the following elements are saved with the bookmark:

  • The current page
  • Filters
  • Slicers, including slicer type (for example, dropdown or list) and slicer state
  • Visual selection state (such as cross-highlight filters)
  • Sort order
  • Drill location
  • Visibility of an object (by using the Selection pane)
  • The focus or Spotlight modes of any visible object


For further information, please refer to the document .



Best Regards



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi Allan,


Thanks for the comment and your suggested solution.

I have to present like below visual where colours should be represent by buttons for each equipment (e.g. ICR2-POA,ICR4-POA.....) but it is not possible as we can't apply filter on buttons for equipment. Here, I have used card and applied background condition formatting but the problem here is the size of the card is bit larger than buttons. 

So, still looking if these cards can be replaced by buttons.









Community Champion
Community Champion

Hi @jitpbi ,


See if this video helps.



Harsh Nathani

Super User
Super User

@jitpbi , if you want to color in matrix/table/ display it is possible. But if you want in slicer it is not.


You can create a measure like give below and use that in conditional formatting with "field" option.

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" && sum(Table[Value]) >500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" && sum(Table[Value]) >1000,"lightgreen",
/// Add more conditions


You can check the custom filter for slicer



Thank you for the solution.


I have used the below measure:


Colour = SWITCH(
                              FIRSTNONBLANK('Button Colour'[Current Status],"NA")="Healthy","green",
                              FIRSTNONBLANK('Button Colour'[Current Status],"NA")="Anomaly","orange",
                              FIRSTNONBLANK('Button Colour'[Current Status],"NA")="Prolonged Anomaly","yellow")
I am using button to show the colour but here i am not able to apply filter on equipment field. So, if i want to use a button for each  different equipment then how to achieve it.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.