Forum Discussion

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

How to Remove blank data in matrix table

How to Remove blank data in matrix table. I need only show the value please refer to the image below    
data protection
Need Help
Show and Tell
  • Daniel29195's avatar
    Daniel29195
    2 years ago

    Sugumaran31  for sure.

    so i think  in the return of the growth % measure , you could write something like this . 

     

     

    growth % = 

     

    var numerator = [growth] 

    var denominator = [sales PYD]

    return

    switch ( 

    true() ,

    isblank( numerator) ,  blank() ,  divide ( numerator , denominator ) ) 

     

    let me know if this helps. 

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

Hi Sugumaran31 - you can create a measure for Sales CYTD,Sales PYTD and growth as follows

SalesCYTD_NonBlank =
IF(
ISBLANK([Sales CYTD]),
BLANK(),
[Sales CYTD]
)

 

similarly

SalesPYTD_NonBlank =
IF(
ISBLANK([Sales PYTD]),
BLANK(),
[Sales PYTD]
)

 

and for growth too.once created the above measures for three fields, created a condition or flag with blank() or 1 for non blank metric

 

add the below measure in filter pane:

 

NonBlankMetrics =
IF(
ISBLANK([Sales CYTD]) && ISBLANK([Sales PYTD]) && ISBLANK([Growth]),
BLANK(),
1
)

 

In the Filters pane, drag the NonBlankMetrics measure to the Filters on this visual area.Set the filter condition to is not blank.

 

try the above approach and let know.

 

Did I answer your question? Mark my post as a solution! This will help others on the forum!
Appreciate your Kudos!!