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.
I upload my PBIX in my g drive, it will be easier to understand for you
Do not hesisate to ask if something is not clea
https://drive.google.com/file/d/1KY6DAcgzTii7AfwOGJ3PqIeE2Fh2yXL_/view?usp=sharing
thanks for sharing , this works but i also want to see list of subjects meeting that criteria in filter which is not happening if subject has both yes and no it does not work
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.
Thanks for the response , calculated column doesn't work in this case only measure works
