Forum Discussion

Krish89's avatar
Krish89
Icon for Helper II rankHelper II
5 years ago
Solved

Remove rows with the value 0 in Matrix visual

Hi Power BI Community,

 

I have a PBI report where I would like to plot the sales data based on the Electonics type for each month..

I have a table "ElectronicsSales" with a column called "Electronics" which has a list of all electronics and other column called "Revenue".

I created a measure.

Sales Revenue= Sum( ElectronicSales[Revenue] )

Now in the matrix visual, I put

Rows field = Electronics

Columns filed = Date 

Values = Sales Revenue measure

The result is something like below screenshot.

But i would like to remove the row Cameras which has 0 for all the months and just want to show remaining rows.

In simple words, I would like to remove the rows which has 0 for all the months from the matrix visual.

 

Thanks in advance

 

 

  • Krish89 ,

    Try a measure like 

    Measure =

    var _1 =Sum( ElectronicSales[Revenue] )

    return

    if(_1=0 , blank(), _1)

4 Replies

  • Krish89 ,

    Try a measure like 

    Measure =

    var _1 =Sum( ElectronicSales[Revenue] )

    return

    if(_1=0 , blank(), _1)

      • v-deddai1-msft's avatar
        v-deddai1-msft
        Icon for Community Support rankCommunity Support

        Hi Krish89 ,

         

        Just use the following measure:

         

        Sales Revenue= Sum( ElectronicSales[Revenue] )+0

         

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

         

        Best Regards,

        Dedmon Dai

    • SuruboiR's avatar
      SuruboiR
      New Member

      could u pls share measure DAX formula again, given formula is not working.