Filter rows with blanks

[Anonymous]

This may be a very easy fix, but I'm strugling.

Here is the link to pbix

https://1drv.ms/u/s!AumyvtVXEve9jMBCAtpnN8EoNd3dKQ

I just don't want to see rows, where there is no value. Thanks in advance

[Anonymous]

Hi @Anonymous

In the Visualizations tab- > Fields Tab-> Right click your object/ column and unselect the "Show items with no data" option.

 

Thanks
Raj

[Anonymous]

@AnonymousThat does not work, did you open the pbix?

[Vvelarde]

@Anonymous

Hi, if you remove "1 or 2 measure" this rows dont be show it.

Regards

Victor

[Anonymous]

@VvelardeYes, but I need that, so I can put Traffic Light icon there. Otherwise yes, it would not show.

[Vvelarde · Accepted solution]

@Anonymous

Ok.try with this

1 or 2 =
IF (
    ISBLANK ( [Sum of Sales] ) && ISBLANK ( [Sum of Sales2] ),
    BLANK (),
    IF ( [Sum of Sales] - [Sum of Sales2] > 0, 1, 2 )
)