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 ...
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
tex628's avatar
tex628
Community Champion
6 years ago

Is profit and inflow measures?

EdgarasR1's avatar
EdgarasR1
Frequent Visitor
6 years ago

Nope, columns from excel

  • 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.

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