Forum Discussion
Change callout value color based on parameter
jalenm ,
You can create a measure, There you can use a whatif parameter measure or a meausre
Example
Meausre = Switch( True() ,
[Bedrag Running Total Bedrag] < [What if] , "Red",
[Bedrag Running Total Bedrag] < [What if 2] , "Green" )
Use this in conditional formatting using field value option
You can also use min and max value of what if
new measure =
var _max = maxx(allselected(whatif),whatif[value])
var _min = minx(allselected(whatif),whatif[value])
returnSwitch( True() ,
[Bedrag Running Total Bedrag] <_min , "Red",
[Bedrag Running Total Bedrag] < _max , "Green" )
My bad for not being clear enough. I don't want to change the number that the field is based on (That bedrag running total is correct and it already works properly) But I want the user to be able to choose an amount with a slicer parameter. Then the value they have selected should replace the 13,000 number from the image. The 13,000 number I put there is just a placeholder but it should be a dynamic number from the parameter.
Super Userjalenm ,
You can create a measure, There you can use a whatif parameter measure or a meausre
Example
Meausre = Switch( True() ,
[Bedrag Running Total Bedrag] < [What if] , "Red",
[Bedrag Running Total Bedrag] < [What if 2] , "Green" )
Use this in conditional formatting using field value option
You can also use min and max value of what if
new measure =
var _max = maxx(allselected(whatif),whatif[value])
var _min = minx(allselected(whatif),whatif[value])
return
Switch( True() ,
[Bedrag Running Total Bedrag] <_min , "Red",
[Bedrag Running Total Bedrag] < _max , "Green" )
Thank you so much! Honestly I probably would have never thought of that solution.