Year and Quarter Parameter Filter

[Bismeet]

I am trying to build a filter by date and respective Quarters similar to what is shown in the image.  This works using a simple slicer but I am looking for building this in a user-friendly and interactive way. So will I have to create a bookmark for each and every combination of year and quarter? Is there a more intuitive way?

[v-juanli-msft · Accepted solution]

Hi @Bismeet 

Change the columns to text type, then add them into a default slicer.

Turn off the "responsive",

You could also add a shape, then put the shape layer at the bottem, then click+ctrl on slicers and shapes and right click on mouse to select "group".

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Bismeet , not very clear to me

refer if this can help

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380786?tab=Overview

[Bismeet]

No,  I was looking for a button type interface to filter. And also, since the user can select multiple quarters, this leads to a very large combination of bookmarks @amitchandak 

[amitchandak]

@Bismeet , when you change orientation or slicer to horizontal they look like a button. explore if that can help

https://docs.microsoft.com/en-us/power-bi/power-bi-slicer-filter-responsive