Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
samuelstinger
Frequent Visitor

Iterate over filter (slicer) values with button

Hello all!

 

Does anyone know how to iterate over a filter (slicer) with a button (or something else)?

Especially this interesting in mobile mode.

Maybe you know custom visuals for this?

 

Thanks! 

1 ACCEPTED SOLUTION

You can (ab)use a play axis visual for that but I think your suggestion makes sense, and warrants its own implementation. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com

View solution in original post

6 REPLIES 6
lbendlin
Super User
Super User

You can use the standard slicer visual. Change it to horizontal layout which will give you button-like behavior.

Thank you, lbendlin!

This method is suitable for desktop mode, but not very convenient in mobile mode.

I will keep looking...

 

Hey @samuelstinger ,

 

Can you please explain why Slicer buttons view is not convenient in mobile view? Can you elaborate more about what would be more convenient in your opinion?

 

Thanks, Maya

Hello, Maya!

Thanks for your reply!

I will try to explain my point.

 

Let you need to iterate by some field. This field contain many rows (for example 100 or 1000).

And some charts depend on this field. 

A user wants to sequentially view the data for each selected value. 

If you choose to implement a slider as a dropdown, the user must click on the slider, scroll to the next value and click on this value. And it should be every time. 

If you choose to implement the slider as a tiles, then it will take many space in screen and it will be not very useful, because the user will have to scroll to the next value and select it manually.

 

if there was a way to do this with two buttons "Prev" and "Next" it would be very convenient.

 

Thanks!

You can (ab)use a play axis visual for that but I think your suggestion makes sense, and warrants its own implementation. If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.powerbi.com

Thanks, lbendlin!

I added this as an new idea (link).

Thank you all for your help!

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors