Is Year, Month slicer with Scattered layout exist? screenshot attached

[dongchen]

Is this type of slicer in PowerBi existing? A similar one also works!

Thanks in advance. 

[v-henryk-mstf · Accepted solution]

Hi @dongchen ,

According to your needs, first change the slicer to list format, and then change it to horizontal format in Format->General->Orientation. Refer to the following:

If the problem is still not resolved, please provide more information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@dongchen , to me, seems like Slicer(list) with Horizontal orientation.

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

[dongchen]

Tried this approach. 

The `date` I used has Date Hierarchy. I created two Slicer Visual and put `Year` in Date hierarchy in one visual and `Month` in Date hierarchy in the other Visual. 

For the `month` in the other Visual, I got this. It looks good, but when I click on one month in this Visual, I am not sure if the `toggle` effect is there. It means it toggles on the month and use that month as a single value filter. And the `format` on this visual is possible to set to the `horizontal`. 

However, in this `Year` Visual, there is no option to set the `Horizontal` in format - General field. 

Also, it didn't feel right to me. That's not a `toggle`. That's a year range selector.  Maybe its value is a number? 

This solution feels right but actually not there yet from an implementation perspecive

Need more advice. 

[amitchandak]

@dongchen , Prefer to use columns than hierarchy.

Year, first change to list and then try

You can do single and multi select same as list box

[dongchen]

Thank you for helping.

When you say `list`, do you mean define `Year` column to a `Data type` or `Data Category` or something else?