Forum Discussion
power bi parameter
Hello ArvindJha
Try creating a calculated column instead of measure based on the required condition, it will return "Yes" or "No" for each row. Once this calculated column is created, you can use it in your visuals and slicers to filter and display data according to whether the subject meets the specified criteria.flag_column =
if(
sheet1[prevvalue] < [threshold value] && sheet1[currvalue] >= [threshold value],
"yes",
"no"
)Thanks and Regards.
static values work
Hi ArvindJha
Follow these steps
1) create a numeric range with the following parameters
2) create the following measure
Flag Measure = IF (
SELECTEDVALUE('Sheet1'[PrevValue]) < 27 && SELECTEDVALUE('Sheet1'[CurrValue]) >= Threshold[Threshold Value],
"Yes",
"No"
)3) Add it in the tableau
4) play with the sclicer
Result with a smaller value
Result with a higher value
it is normal, when you create a calculated column, the column will read the static value and then won't change, it is the same with a slicer parameter
It will change only when you refreshed the semantic model
The measure will be refresh each time something changed on the visual
