Remove rows with the value 0 in Matrix visual

[Krish89]

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

[amitchandak · Accepted solution]

@Krish89 ,

Try a measure like 

Measure =

var _1 =Sum( ElectronicSales[Revenue] )

return

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

[SuruboiR]

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

[Krish89]

@amitchandak ,

Thank you very much for quick response and it helped.

[v-deddai1-msft]

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