Slicer Settings

Hi b-kopik,

Yes, this happens because the dropdown slicer in Power BI has a visual limit for displaying items, but it does not limit the data. If it’s not showing beyond Qtr 2, it’s likely an issue with sorting or an applied filter, not the slicer size.

Here are some checks and solutions:

1. Check for active filters

• Open the Filters pane and see if there’s any filter restricting the quarters.
• Sometimes another visual or page filter is limiting the data.

2. Confirm column sorting

• If quarters are stored as text (Qtr 1, Qtr 2, etc.), Power BI may be sorting them alphabetically.
• Solution:
  • Create a numeric order column (e.g., 1 for Qtr 1, 2 for Qtr 2, etc.).
  • Use Modeling > Sort by column to ensure the correct order.

3. Adjust slicer type

• The dropdown doesn’t show a visible scroll by default, but you can:
  • Enable the scroll bar: Go to Format > Slicer settings > General > Scroll bar.
  • This allows you to navigate through items without switching to a vertical list.

4. Verify all values exist in the model

• If the data only includes up to Qtr 2, other quarters won’t appear.
• If you want to show all quarters even without data, create a calendar table with all periods and relate it to the model.

Quick solution summary:

• Enable the scroll bar in the dropdown slicer.
• Check for hidden filters.
• Ensure the data includes all quarters or use a calendar table.

I think this code will help you.
Don’t forget the kudos, it costs you nothing and we help each other. Cheers.