Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filter rows with blanks

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 ...
Need Help
  • Vvelarde's avatar
    Vvelarde
    7 years ago

    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 )
)
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Anonymous
    Not applicable
    7 years ago

    AnonymousThat does not work, did you open the pbix?

    • Vvelarde's avatar
      Vvelarde
      Community Champion
      7 years ago

      Anonymous

       

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

       

      Regards

       

      Victor

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

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