Forum Discussion
Helper IRealtive Date Slicer
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.
3 Replies
david40niHi 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
v-chuncz-msftCommunity Support
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 ?