Imagine I have a table that has phone calls. And for each call done there is an agent linked to it. I created a table that contains all the possible agents and with that I made a slicer that will allow me to see the calls an agent has done by having a measure that counts them and a visual that shows it. Now I want to make the slicer only show the agent "options" that are relevant. For example, imagine I filter my page by date (forgot to say that each of my calls contained a date) and so the measure that counts phone calls changed accordingly and everything, but there are agents which really contribute nothing to the total, and that if I filter by them I will see they have 0 calls, is there any way to be able to make it so that the slicer doesn't show agents with no phones linked to them?
I know it's a little abstract and everything so if I haven't been able to explain myself I will try to create a new pbix so that it's more visual but for now let's see if someone can get it without it.
I'm trying to get what this guy shows in the first part of this page but what he does doesn't seem to work for me:
https://www.kasperonbi.com/showing-only-slicer-data-that-have-facts-in-power-bi-and-other-fun-tricks...
