Forum Discussion

jitpbi's avatar
jitpbi
Post Patron
6 years ago

Fill button colour based on field value

Hi,   I have to show Equipment's current status by 3 different colours, using button, based on current status field's value:   Equipment Current Status Amp1 Healthy Amp2 Anomaly Am...
Need Help
v-alq-msft's avatar
v-alq-msft
Community Support
6 years ago

Hi, jitpbi 

 

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

Measure = 
SWITCH(
    SELECTEDVALUE('Table'[Current Status]),
    "Healthy","Green",
    "Anomaly","Red",
    "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

Allan

 

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

  • jitpbi's avatar
    jitpbi
    Post Patron
    6 years ago

    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.

     

     

     

     

     

    thanks