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 advance

 

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 )
)

5 Replies

  • 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