Fill button colour based on field value

[jitpbi]

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
Amp3	Prolonged 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,

[v-alq-msft]

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]

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

[harshnathani]

Hi @jitpbi ,

See if this video helps.

https://www.youtube.com/watch?v=0m-PCX1uCG4

Regards,

Harsh Nathani

[amitchandak]

@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-num...
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]

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,