Do not see filter options that have no data

[Syndicate_Admin]

Good night

I have a filter by Sector that has several options. Some of them have no data.

How do I make sure they don't look in the filter?

For example, the "Oranges" sector has no data for this table. I would like it not to appear in the filter.

Thanks a lot

Marcela

[Syndicate_Admin]

Thank you very much @Syndicate_Admin,I have read and I find the solution very interesting but I had the PowerBi in Spanish, I downloaded the English version and the option to add the filter does not appear to me: attached screen and current PowerBi version. Of course, thank you very much

[AllisonKennedy · Accepted solution]

@Syndicate_Admin  Add a filter to the visual level for total sales (or whatever data metric you're reporting on) <>blank

This article should walk you through it: https://www.sqlbi.com/articles/syncing-slicers-in-power-bi/