Forum Discussion
jb_graphic
2 years agoFrequent Visitor
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
- Fowmy
Super User
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_graphicFrequent Visitor
Thanks, That was what I needed to get it to work.