Help needed

[Anonymous]

Hi All,i have three date coulmns like last 3,6,12 months..the data should be populated based on user selection of the date column..how to add three date coulmns to single slicer /filter? Any thoughts

[az38]

Hi @Anonymous 

you can on Power QUery mode pick your 3 date columns then right click and Unpivot only selected columns.

after that it appears one column which could be added as slicer

do not hesitate to give a kudo to useful posts and mark solutions as solution

[Anonymous]

thanks for your response. I have been using SSAS data model ,so there is no pivot query option.