Back to Blog

Power BI Responsive Slicers - Build Filters That Actually Fit Your Report

May 17, 20267 min readMichael Ridland

Almost every Power BI report we inherit from a client has the same problem with slicers. They take up too much room. They look fine on the developer's monitor and then break the second someone opens the report on a smaller laptop screen or, worse, on a phone. The fix is sitting right there in the formatting pane, but most teams have never turned it on.

Responsive slicers solve this. They're not new, they're not glamorous, and Microsoft doesn't talk about them much. But if you build Power BI reports for a living, this is one of those small features that quietly removes a category of complaints from your inbox.

What a responsive slicer actually does

A standard slicer is a fixed lump on your canvas. You set it up, pick a size, and that's the size it stays. If a user resizes the page or opens the report on a smaller display, the slicer either spills its values across multiple lines or chops them off.

A responsive slicer changes behaviour based on the space it has. Make it wider and it spreads horizontally with tile-style values. Squash it and the values stack. Shrink it down to almost nothing and it collapses into a single filter icon you can tap to expand. That last part is the one most people miss, and it's the most useful behaviour on mobile.

It works for two slicer types. Tile slicers (the ones showing values as little buttons) and date or numeric range slicers. The latter also gets nicer round drag handles, which makes a real difference if anyone uses the report on a touchscreen.

How to turn it on

The steps are straightforward but the order matters, because the Responsive toggle is only available after you switch the style to Tile.

  1. Drop a slicer onto the canvas and bind it to a field
  2. Open the Format tab in the Visualizations pane
  3. Under Slicer settings, change the Style from Vertical List to Tile
  4. Under Properties, expand Advanced options
  5. Flip Responsive to On

Once that's done, grab a corner and resize it. You'll see the values rearrange. Drag it down to about the size of a coin and it becomes the filter icon. This is the behaviour you want for phone layouts.

For range slicers, the same toggle exists under properties. Power BI rearranges the input boxes and slider depending on the space. When it gets too small to be useful, the visual collapses to an icon and you double tap to open it in focus mode.

Where this matters in real reports

We do a lot of Power BI work for clients across financial services, mortgage broking, and operations. The pattern is always the same. Executives view dashboards on a desktop in the office, on a laptop in a meeting room, and on a phone between sites. The same report has to work in all three.

Without responsive slicers, what usually happens is the team builds two or three versions of the same report. One for desktop. One for the boardroom screen. Sometimes a stripped down mobile version. That's three reports to maintain, three sets of bugs, and three places where a measure can drift out of sync.

Responsive slicers don't fully fix this. You still want a dedicated phone layout for any report that real people open on a phone. But they significantly reduce the cost of building one, because you can drag your existing slicer into the phone canvas and shrink it to an icon without rebuilding it from scratch.

The phone layout step nobody does

The phone layout feature has been in Power BI Desktop for years. View menu, Mobile layout. You get a portrait grid, you drag your existing visuals onto it, and Power BI uses that arrangement when someone opens the report in the Power BI mobile app in portrait mode.

If you skip this, the mobile app shows the desktop layout rotated sideways, which forces every user to tilt their phone to read the report. People hate this. We've watched executives in meetings give up and ask a colleague to email them a screenshot instead.

The responsive slicer pairs with the phone layout naturally. Drag your slicer onto the phone grid, shrink it down to the filter icon, and now your report has filtering on mobile without eating half the screen. It's the single change we make to inherited reports that gets the most positive feedback.

What's still rough about it

A few honest annoyances.

The Responsive toggle only shows up after you change the style to Tile. If your slicer is a vertical list, the option is invisible and there's no hint in the UI telling you why. We've had clients spend half an hour hunting for it.

The collapse to icon behaviour only triggers when the slicer is genuinely tiny. There's a sort of dead zone where the slicer is too small to show values usefully but too big to collapse. You can usually drag past it, but on tight layouts it's fiddly.

Range slicer behaviour at small sizes is better than it used to be, but the touch handles still take some getting used to. On older Power BI mobile builds we've occasionally seen the slider jump when fingers and the input boxes overlap. Worth testing on the actual phones your users have, not just the emulator.

The other gotcha is that not every visual scales the way you'd expect. The slicer itself is fine. The visuals that respond to the slicer often need their own formatting adjustments to look right at mobile sizes. Card visuals in particular tend to render with awkward font sizes if you don't set explicit values.

How we use this in client work

When we run a Power BI engagement, our checklist for any new report includes turning on responsive behaviour for every tile slicer and every range slicer by default. There's no real downside to leaving it on. If the user never resizes, the slicer behaves exactly like a standard tile slicer.

For phone layouts, we follow a simple rule. If the report is going to be opened on a phone (and most exec dashboards are), the slicer on the phone canvas is always the filter icon. Save vertical space for the chart that actually matters. The same approach works well when we build Power BI integrations into custom AI workspaces where the dashboard is one panel among several.

The other thing we do, which isn't directly about slicers but pairs with this work, is sit with the actual end user for fifteen minutes before publishing. Watch them try to filter. Watch where they tap. You learn more in those fifteen minutes than from any usability checklist.

A small thing worth doing properly

Responsive slicers are one of those features where the documentation makes them sound trivial, the toggle takes two seconds, and the impact on day to day usability is actually quite large. If you're building Power BI reports for an Australian organisation where executives genuinely use the reports on their phones, this is a no brainer.

If you've inherited a Power BI estate that's grown messy over a few years, this is also a cheap quick win to start a cleanup. Open the highest traffic report, switch slicers to responsive, build a phone layout, publish. The complaints quiet down. Then you've got room to talk about the bigger architectural problems.

For teams that need help cleaning up an existing Power BI environment or building something new the right way, that's the kind of work our Microsoft consulting practice does day in, day out. Happy to chat if you've got a report estate that's grown beyond what the team can maintain.

Reference: Create a responsive slicer you can resize in Power BI