Forum Discussion

jb_graphic's avatar
jb_graphic
Frequent Visitor
2 years ago
Solved

How do I filter table to hide rows with "0"?

How do I filter this table to hide rows that have "o" in all three columns.

I have tried the filters but they only seem to work on one column so hide rows with data.

 

If I apply a filter to column it hide rows with Data.

 

 

I would expect it to hide

rows - 1/3/2024, 1/5/2024 & 1/9/2024 but to update for different date ranges.

 

This is what I am using to get the value

#"Added Custom1" = Table.AddColumn(#"Renamed Columns", "Custom", each if [Queue_Time] <= 0.999 and [Queue_Time] > 0.1 then 1 else 0),
#"Renamed Columns1" = Table.RenameColumns(#"Added Custom1",{{"Custom", "0-1_hrs"}}),

 

Thanks
Jason

 

 

  • jb_graphic 

    Change 0 to null

     

    #"Added Custom1" = Table.AddColumn(#"Renamed Columns", "Custom", each if [Queue_Time] <= 0.999 and [Queue_Time] > 0.1 then 1 else null),
    

     

2 Replies

  • jb_graphic 

    Change 0 to null

     

    #"Added Custom1" = Table.AddColumn(#"Renamed Columns", "Custom", each if [Queue_Time] <= 0.999 and [Queue_Time] > 0.1 then 1 else null),
    

     

    • jb_graphic's avatar
      jb_graphic
      Frequent Visitor

      Thanks, That was what I needed to get it to work.