How to colour some data in a table according the slicer selected

[Anonymous]

Hi all,

I need to colour some data of a specific table. I want to do that according a specific value entered in a slicer.

P.e. I choose 85. For Tª max <85 i want to colour in red; Tª max >85 in green

Have a look of my table.

How can iI do that?

Thank you for your support!

[v-robertq-msft · Accepted solution]

Hi, @Anonymous 

According to your description, you want to set the value color based on the Slicer value, you can follow my steps:

1. Create a measure(replace the table and column name with your current name):

Background color =

var _selected=SELECTEDVALUE('Ta Slicer'[Ta Slicer])

return

IF(MAX('Table'[Ta max])<_selected,"red","green")

2. Go to the table chart->conditional formatting->background color on->advanced controls, then set like this:

Then set the field font color to white, and you can get what you want, like this:

You can download my test pbix file here

Best Regards,

Community Support Team _Robert Qin

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

[amitchandak]

@Anonymous , Create a color measure like given below and use that in conditional formatting option using "Field Value"

if([T max] <selectedValue('T Slicer'[Value]) ,"Red" , "Green")

Refer docs for steps 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

[speedramps]

Please consider this solution

Don’t forget to accept the solution and/or click the thumbs up to leave kudos. Thank you!

Create a list of temperatures for your slicer, and a table of temperatures for your report.

Add this dax measure

RAG =

VAR mintemp = MIN(Mylist[Temperature])

VAR maxtemp = MAX(Mylist[Temperature])

RETURN

SWITCH(TRUE(),

SELECTEDVALUE(Mytable[Temperature]) < mintemp , "red",

SELECTEDVALUE(Mytable[Temperature]) > maxtemp , "red", 

"green"

)

 
In the report right click on Temperature > conditional formatting > background colour > format by = field value > based on field = RAG

Click here for example

https://1drv.ms/u/s!AgMTUY3Uvq3bg4kNji3xnt8L66tcDA?e=Hcotxn