Realtive Date Slicer

[david40ni]

I cannot for the life of me find the relative date slicer at all, I have date column which I want to give the option of the past 12 months say a person chooses q4 from periods then they choose 2017 it would auotomatically show them a comparison of the past 12 months is that possible I am new to power bi so please be gentle to me.

[v-chuncz-msft]

@david40ni,

Note the data type under Modeling tab and take a good look at this discussion.

http://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373

[david40ni]

Is there anything that allows me to show a comparison say of the last 6 months or 12 months of data. I no it will filter the data but i want to give them two graphics one showing past six months and one showing past 12 months ?

[david40ni]

Hi we have a requirment where a customer requires to be able to see the last 12 months from the selective year I was going use the realtive date slicer but I cannot see the relative option under the carret the date times are stored as dd/mm/yyyy but I see no realtive option