powerpivot - Minute | Hour | Day | Week | Month | Year | filter for Power View charts in Power BI - Disconnected Slicer -

i want create power view chart in power bi minute/hour/day/week/month/year filters:

workbook can downloaded at: https://www.dropbox.com/s/r00btg5zb8snohz/disconnected%20slicer%20demo.xlsx?dl=0

when minute selected chart should display:
total number of msgs vs. x-axis showing last 60 seconds (from current time) 5 or 10 seconds interval.

when hour selected chart should display:
total number of msgs vs. x-axis showing last 60 minutes (from current time) 5 minutes interval.

ex: 10:00am 10:05am 10:10am ...................................11:00am

when day selected chart should display:
total number of msgs vs. x-axis showing last 24 hours (12am 11:59pm 1 hour interval)

when week selected chart should display:
total number of msgs vs. x-axis showing last 7 days current datetime stamp 1 day interval.

when month selected chart should display:
total number of msgs vs. x-axis showing 30 days current datetime stamp 1 day interval

when year selected chart should display:
total number of msgs vs. x-axis showing last 12 months current day 1 month interval

it great if powerview chart can made this:

shown in below link:

when '5 day' selected values in y axis , x axis change automatically.

here's link:

https://www.google.co.in/search?&biw=1600&bih=799&sclient=psy-ab&q=google+share+price&oq=google+share+price&gs_l=serp.3..0l4.148.192.3.270.2.0.0.2.2.0.0.0..0.0.msedr...0...1c.1.60.serp..0.2.11.jf8jxyugmda&pbx=1&bav=on.2,or.r_qf.&bvm=bv.82001339,d.dgy&ech=1&psi=qcgpvjmejohgmqxsoodacq.1418707370733.9&ei=nsopvjgii6ggmqw0g4laba&emsg=ncsr&noj=1

more clarifications , information please feel free reach out me @ manjunath.hireholi@gmail.com

www.twitter.com/mph88

you can use disconnected slicer this. example, have table of dates , values called table2.

i add data disconnected slicer in table1.

this table contains day, week, month, , year in date selection column. days column contains number of days today. sort column used values show in preferred order in slicer.

i downloaded date dimension azure data market (i use datestream because it's , free). don't have use one, need date table set of contiguous dates.

first, need create relationship between date table , values table. relationship goes [table2[date] basiccalendarus[datekey].

need calculation date selection.

selected timeframe:=max('table1'[days]) 

finally, need sum of values respects date selection slicer.

dateframe sum:= calculate(sum([sales amount]),  datesinperiod(basiccalendarus[datekey],today(),[selected timeframe],day)) 

then can put in power view.

i add date selection field slicer. add dateframesum calculation , date table2 in line chart , in table. when choose month, see values in last 30 days (this excludes value tied june 15). when choose week, values last 7 days shown. needs cleanup on data viz make nice, shows functionally how can work.

you can see explanation , example of disconnected slicer date selections @ http://www.powerpivotpro.com/2013/08/moving-averages-controlled-by-slicer/#more-7966