How to Remove blank data in matrix table

[Sugumaran31]

How to Remove blank data in matrix table. I need only show the value please refer to the image below

[rajendraongole1]

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!!

[Daniel29195]

@Sugumaran31 

you have multiple approach 

you can filter from the filter pane on the visual level,  where the measure  growth is not blank () . 

another approach would be . 

using a switch( ) in the code of the growth %, 

and returning blank() if growth is blank() .

let me know if this helps. 

[Sugumaran31]

@Daniel29195 But the filter pane on the visual is not working how do I use the switch function can you give me an example

[Daniel29195 · Accepted solution]

@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.