Custom Pass/Fail Thresholds in Power BI Table Visuals

hoosha_11 add at the source (in the semantic model)

Hi parry2k ,thanks for the quick reply, I'll add further.

Hi hoosha_11 ,

I noticed that your connection mode is Live connection, maybe you can use the conditional format.

The Table data is shown below:

Please follow these steps:
1. Use the following DAX expression to create a measure(The user can just change the score in the expression)

Measure = IF(SELECTEDVALUE('Table'[Score]) >= 80 ,"Pass","Fail")

 2.Use the following DAX expression to create a measure

Measure 2 = IF([Measure] = "Fail","RED","GREEN")

3.Setting the Conditional Format

4.Final output

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

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