Forum Discussion

ERing's avatar
ERing
Icon for Post Partisan rankPost Partisan
2 years ago

Help with visual error when filter is applied

I'm getting an error in in my table visual when I apply a filter to select a specific dimension. The visual is a table with 2 columns. The first column is the Actual % and the second column is the...
Need Help
Idrissshatila's avatar
Idrissshatila
Icon for Super User rankSuper User
2 years ago

ERing , it seems that in your table there's a N/A value that is affecting the column, if so replace it with zero.

  • ERing's avatar
    ERing
    Icon for Post Partisan rankPost Partisan
    2 years ago

    Idrissshatila  I'm not quite sure how to resolve this. I've tried IF = NA in DAX but that isn't working. Any tips?

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi ERing 

      Did you put the text 'N/A' in the column, if it exists in the column, you need to replace the 'N/A' to  blank or 0, or the data type of the column will be the text instead of number.

       

      Best Regards!

      Yolo Zhu

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