Tip week- Tip four, day four

Here a new tip for you on filtering. Have you ever wanted to eliminate a Null from you filter but when you click back on ‘All’ the ‘unwanted item’ comes back again?

The only way to eliminate this problem is to create a new set. If your value is a measure you must then make a copy and drag it to dimension and then create a new set. You then drag it to filter and you have your filter fixed. Here a video to better understand this:

Author:
Giorgia Umani
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab