Forum Discussion

EdgarasR1's avatar
EdgarasR1
Frequent Visitor
6 years ago
Solved

Filter by two columns

Hello,

 

I have a problem that seems like a easy task but can't figure out.

 

I have visualization by two columns:

 

And I want that payments (profit and inflow) dissapear  where is both 0 in one row . But I can't combine them, I need just like a filter that where is both 0 wouldn't be in visualization. Or just somehow to put 120 and 45 and others payments above 0. 

 

Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    6 years ago

    If it's columns, then create a calculated column

     

    Calculated Column = IF('Table'[Iplaukos] = 0 and 'Table'[Pajamos] =0, "Yes", "No")
     

    And then jsut add this column to visual filters in the filter pane and filter it out.

  • Anonymous's avatar
    Anonymous
    6 years ago

    Hi EdgarasR1 ,

     

    Try creating a column in the table

     

    Condition = IF(TableName[Profit] = 0 && TableName[Inflow] = 0, "Y","N")
     
    By doing this, it will give you a column with Y and N where both profit and inflow are 0 then it will be "Y".
     
    Now on the visual just add this column to the filters panel and exclude N.
     
    BR,
    U

4 Replies

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        If it's columns, then create a calculated column

         

        Calculated Column = IF('Table'[Iplaukos] = 0 and 'Table'[Pajamos] =0, "Yes", "No")
         

        And then jsut add this column to visual filters in the filter pane and filter it out.