Preselected Custom Slicer

Hey there! 👋

This issue happens a lot when using preselected slicers — the default value works fine, but the slicer still shows all attributes from every country, right? 😅

Here are a couple of ways to fix it 👇

🩹 Option 1: Quick check

Go to your slicer settings and turn off “Show items with no data.”
That usually fixes it right away, since it forces the slicer to only display values that exist for the selected country.

But — if you’re using a custom visual like Preselected Slicer — it might ignore that setting. In that case, go for Option 2 👇

🧠 Option 2: Create a visibility measure

You can create a small measure that only returns 1 for attributes that actually have data for the selected country (and optionally disease).

Here’s a simple version:

Show Attribute (by Country) =
VAR _Country = SELECTEDVALUE(ff_country_d[country_code])
RETURN
IF(
ISBLANK(_Country),
1, // show all if no country selected
IF(
CALCULATE(
COUNTROWS(ff_summary),
ff_summary[country_code] = _Country
) > 0,
1, 0
)
)

If you also want it to react to the disease filter:

Show Attribute (Country + Disease) =
VAR _Country = SELECTEDVALUE(ff_country_d[country_code])
VAR _Disease = SELECTEDVALUE(ff_summary[custom_disease_code])
RETURN
IF(
ISBLANK(_Country) && ISBLANK(_Disease),
1,
IF(
CALCULATE(
COUNTROWS(ff_summary),
(_Country = BLANK() || ff_summary[country_code] = _Country),
(_Disease = BLANK() || ff_summary[custom_disease_code] = _Disease)
) > 0,
1, 0
)
)

✅ How to use it

1. Add your attribute field to the slicer.

2. In the Filters pane (for the visual), add the measure Show Attribute....

3. Filter it to show only values where it equals 1.

4. Optional: turn off Show items with no data just to be safe.

That should do the trick 🎯
Your slicer will now only show the attributes related to the selected country (and disease, if included), while keeping your preselection logic working perfectly.

Hope it helps! 🙌