Change button colour

Question

Hi,&nbsp;I have to dynamically change the colour of a button based on the field's value. The filed has 3 different values 0,1 &amp; 2, please refer the below example:&nbsp;Field ValuesButton Color0Green1Orange2Yellow&nbsp;I had tried through conditional formatting, in the fill color option, but it takes only aggregated value. Please help to achieve this.&nbsp;Thanks

amitchandak · Answer

jitpbi , You can use color measure, with field option. But I found an issue with slicer color : https://community.powerbi.com/t5/Issues/Field-Conditional-formatting-is-not-working-in-slicer/idi-p/1228974#M59165
Color sales = if(AVERAGE(Sales[Sales Amount])&lt;170,"green","red")
Color Year = if(FIRSTNONBLANK(Table[Year],2014) &lt;=2016,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)&gt;2018,"red","yellow"))

Color  = if(FIRSTNONBLANK(Table[Year],2014) &lt;=2016 &amp;&amp; AVERAGE(Sales[Sales Amount])&lt;170 
,"lightgreen",if(FIRSTNONBLANK(Table[Year],2014)&gt;2018,"red","yellow"))
Color sales = if([Sales Today] -[sales yesterday]&gt;0,"green","red")

color =
switch ( true(),
FIRSTNONBLANK(Table[commodity],"NA") ="commodity1" &amp;&amp; sum(Table[Value]) &gt;500,"lightgreen",
FIRSTNONBLANK(Table[commodity],"NA") ="commodity2" &amp;&amp; sum(Table[Value]) &gt;1000,"lightgreen",
/// Add more conditions
"red"
)
,
link how to use color measure
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-columnhttps://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

jitpbi · Answer

Hi,&nbsp;&nbsp;I have tried with the following measure but it's picking up the green colour only for each value:&nbsp;Measure = SWITCH(TRUE(),FIRSTNONBLANK('Entity State'[State],"NA") = 0,"green", &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FIRSTNONBLANK('Entity State'[State],"NA") = 1,"orange", &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; FIRSTNONBLANK('Entity State'[State],"NA") = 2,"yellow")&nbsp;Thanks,

fowmy · Answer

jitpbi&nbsp;User Field Value in CF under fill color and assign the Measure below, Button Color Field can have actual color name or HEX Codes_Color = 
VAR _SELECTED = SELECTEDVALUE('Table'[BUTTON COLOR])
RETURN
    _SELECTED&nbsp;&nbsp;&nbsp;&nbsp;If you are satisfied with my answer, please mark it as a solution so others can easily find it.Don't forget to give KUDOS to replies that help answer your questionsSubscribe to ExcelFort: Learn Power BI, Power Query and Excel&nbsp;

anonymous · Answer

HI&nbsp;jitpbi,
You can create a table visual with your records and configure these fields to summarize mode 'do not summarize'.Then you can apply conditional formatting on 'button color' fields with raw fields values instead of aggregate values.
Regards,
Xiaoxin Sheng

jitpbi · Answer

Hi, I have tried after&nbsp;configuring the field to summarize mode 'do not summarize' and used conditional formatting in "Fill" option of button but it's not working.&nbsp;My Field has three values : 0,1,2 and i need three different colours for these values.&nbsp;Thanks

Forum Discussion

Change button colour

7 Replies

Related content

Button colour

remove button colour fill function

Button

Change Colour in Slicer Search Field

Need to change the colour of Slicer 'Clear Selection' Button

Field Values	Button Color
0	Green
1	Orange
2	Yellow