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. 

4 Replies

  • Daniel29195's avatar
    Daniel29195
    Icon for Community Champion rankCommunity Champion
    2 years ago

    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's avatar
      Sugumaran31
      Icon for Helper I rankHelper I
      2 years ago

      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's avatar
        Daniel29195
        Icon for Community Champion rankCommunity Champion
        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!!