Need a date picker with only Year and Month

[kumar27]

Can we have a date picker (like calendar) with only Year and Month within pbi ? (there should.nt be any days) .

I've seen "timeline slicer " but the spacing is a issue to use it !

[visheshjain]

Hi @kumar27,

I doubt that you can do that.

An alternative would be to use the year month column from your calendar table and make the slicer values to be shown as a grid of the size that you choose, like this.

You can do this by selecting the slicer and then under the formatting pane of the visual go to Slicer Settings > Options > Style

Hope this helps!

[kumar27]

Thanks @visheshjain for you reply .  the problem with this is the amunt of space it will take 

[visheshjain · Accepted solution]

Hi @kumar27,

You can make the visual smaller as per your requirement.

Yes, it does NOT give the exact result you want, but its a workaround.