I had a requirement where I had a related table (or dimension table) in which was used as a slicer. But when it was changed to a slicer it was showing all the values in the related table, even if there was no data. So below I show and explain how to overcome this and show how to filter a slicer…