How to create a text column so to be used as a slicer

[Anonymous]

Hi,

Can anyone suggest me how to achieve the below scenario.

I have a data set (Direct Query) with individual Time periods as week,Quarter & year.

I need to create a text column (Period) as below and use the column as a drop down filter.How to create it?

Period

Weekly

Quarterly

Yearly

when selected Weekly on Period filter it should point to week column and when selected Quarterly it should point to Quarter column. etc...

and how do my visuals axis get changed accordingly.

I hope my question is clear.

Regards,

DD