Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hiding values in matrix visual

Hi all,

 

I have a matrix visual showing median values by job family and job level. I want to hide all values that are either <100% or >100%. Until now, I've tried fixing it by 

1) Show only values between -100% and +100% (exclusive) in the filter pan

2) Adding IF and BLANK functions in the measure I use for my matrix values

  

However, both approaches have failed. Does anyone know how to find a way around this?

 

 

Thanks,

Fizzy_Mojito

Need Help

6 Replies

  • mahoneypat's avatar
    mahoneypat
    Icon for Microsoft Employee rankMicrosoft Employee
    5 years ago

    Please try this expression.

     

    NewMeasure = var vMale = [TTC Median Male]

    var vDiff = vMale - [TTC Median Female]

    var vResult = IF(vDiff<=-1 || vDiff>=1, BLANK(), DIVIDE(vDiff, vMale))

    return vResult

     

    Pat

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    If these records did not really exist in your table, you can't directly use if statement to handle them.
    For this scenario, you need to create a new table with all category type values to replace the raw fields you used on the matrix.
    After these steps, you can write a measure with selectedvalue function to extract value and replace displayed values.

    My Favorite DAX Feature: SELECTEDVALUE with SWITCH 

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago
      For this scenario, you need to create a new table with all category type values to replace the raw fields you used on the matrix.

      Would you mind elaborating more on what you mean by this? I'm happy to share more on my original dataset, if helpful.