Forum Discussion

hoosha_11's avatar
hoosha_11
Icon for Helper I rankHelper I
2 years ago
Solved

Custom Pass/Fail Thresholds in Power BI Table Visuals

Hi,   We have a table visual with a 'Score' column. If the score is greater than 80, it's considered a 'Pass' with a green background; if it's less than 80, it's marked as 'Fail' with a red backgro...
Need Help
  • parry2k's avatar
    parry2k
    2 years ago

    hoosha_11 add at the source (in the semantic model)

  • Anonymous's avatar
    Anonymous
    2 years ago

    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.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
2 years ago

hoosha_11 add at the source (in the semantic model)