How to filter Blank value in the measure field

When working with numeric fields in a visualization, you may want to filter out blank values. This can be done by creating an expression column and filtering out null values in that column. Follow the steps below to achieve this

1. Create an expression column

Create an expression column for the numeric field with blank values. Use the following expression format:
[ColumnName]::varchar

Replace column name with the name of the numeric field you want to filter.
Expression : [InherentImpact4729]::varchar

2. Add the Expression Column to Filters

Add the newly created expression column to the Filters section of your visualization.

3. Filter Out Null Values

Filter out null values in the expression column to remove blank values from your visualization.

By following these steps, you can successfully filter out blank values in a numeric field.

Additional References

• Working with Expressions
• Filtering Data in Visualizations