Forum Discussion
Solved
Can you ask a filter to no show all results if less than X amount of rows?
Hi, I'm working on a culture survey analysis for a client and I'm facing two things to solve. The first one is with a filtered table, for confidentiality I would like the results to be filtered if th...
Ah, thank you SergeiBaklan 🙂
Then the data source may be dynamic, avoiding 'blanks' in the pivot table, by using a named range that adjusts to the filtered data by referring to
=OFFSET($P$5,0,0,ROWS($P$5#),COLUMNS($P$5#))where P5
=FILTER(Table1[[#All];[Date]:[Amount]];Table1[[#All];[Display]]<>"********")
Afraid Power Query won't work on Mac.
Ah, thank you SergeiBaklan 🙂
Then the data source may be dynamic, avoiding 'blanks' in the pivot table, by using a named range that adjusts to the filtered data by referring to
=OFFSET($P$5,0,0,ROWS($P$5#),COLUMNS($P$5#))
where P5
=FILTER(Table1[[#All];[Date]:[Amount]];Table1[[#All];[Display]]<>"********")
- thank you! will try it out as I'm moving forward offering a dashboard as a product with Culture Surveys now, keeping confidentiality is important here. 😄
- Sure is. You're welcome, and good luck 🙂
