Clean up a dimension table

Question

My dimension tables contains more rows than my fact table, I would like my dim table fields to show only the values in the fact table when used as a filter in the filter panel.What cleaning/modeling steps are the best to achieve this.

I also know how to write sql if that is an option for an answer.

Answer 1

Rather than use a table for your dimension, use a view that has an inner join to the fact table