I have a dimension table and when I place the fields from it to a table visual which is also showing data from a fact table. When I click on the table and open the filters panel I would like to see only those values in my dimension table that are in my fact table.
I know how to solve this when using a slicer but not when using a filter in the filter panel. I have posted an image of my problem below:
