Applying conditional formatting if above user controlled value

[NateSC]

I'm new to Power BI so explain this like I am 5 years old please.

I have a table of data and I would like to use conditional formatting (or some other technique) to highlight values that exceed a certain limit. The trick is that I would like to be able to let the user define that limit. Can I do this through a Value Parameter? I have tried and cannot get it to successfully work.

The table is a sum per day of units scheduled in the system. The parameter would be a max allowed per day. So if the cell in the table exceeded the desired max, it would highlight.

There may be a different approach altogether and I am open to that.

 

[rlv01]

You can specify a changable limit for a conditional formatting rule by using a cell to hold the limit setting.

Book4
	A	B	C	D	E
1	Date	Values		Caution limit	Danger limit
2	11-Feb-24	1		5	10
3	12-Feb-24	4
4	13-Feb-24	6
5	14-Feb-24	8
6	15-Feb-24	11
7	16-Feb-24	15
8	17-Feb-24	20
9	18-Feb-24	9
10	19-Feb-24	8
11	20-Feb-24	5
12	21-Feb-24	0
Sheet1

Cell Formulas
Range	Formula
A3:A12	A3	=A2+1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:B12	Cell Value	>$E$2	text	NO
B2:B12	Cell Value	>$D$2	text	NO

 

[NateSC]

rlv01,
Thanks for the reply. I should have specified better in the title that this is in Power BI.

 

[rlv01]

Sorry, my mistake.

 

[NateSC]

No problem. I appreciate you helping.