Bucket as Slicer For Date column

[Anonymous]

Hi All,

I have a requirement where I am displaying Shipment number over shipment date at month level. Now I should have a slicer as below. If month is selected, then shipment have to be displayed by Shipment month. If I select, Quarter, then it should display by grouping Shipment date by quarter and similar to Year.

Anybody have come across such scenarios, please help me to solve this problem. 

Thank You,

Rajesh S Hegde

[Anonymous · Accepted solution]

Hi @Anonymous,
I'd like to suggest you refer to the following blog to know how to achieve the 'dynamic attribute filter' effect on your chart:

Dynamic Attributes In A Power BI Report 
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , One way is do using bookmarks

https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Other option sare

Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://datamonkeysite.com/2020/10/22/change-dimension-dynamically-using-parameter-in-powerbi/