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:

 

EquipmentCurrent Status
Amp1Healthy
Amp2Anomaly
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.

 

Thanks,

 

Need Help

5 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    6 years ago

    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
    "red"
    )

     

    https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
    https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

     

    You can check the custom filter for slicer

    https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

    • jitpbi's avatar
      jitpbi
      Post Patron
      6 years ago

      Hi,

       

      Thank you for the solution.

       

      I have used the below measure:

       

      Colour = SWITCH(
                                    TRUE(),
                                    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.
       
      Thanks,
  • 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