Live performance dashboard.

[mancunian]

Hi guys I posted my question about two weeks but sadly no one replied so I am trying again now here...  I'm trying to create live dashboard on BI and I have data split by 1 hour buckets and i would like to show yoy performance along with last year's YoY pwerformance . therefore there is data for 2016, 2015 and 2014 for three different hotels.  Currently I am using data from an excel but once I have created my dash I will connect live. 

1 . I am not sure how I can get power bi to look at only like for like time bucket throughout the day when calculating yoy growths.  I know I can use same priod last year function but that doesn't do it for like for like time. 

2. I have three year's data but the function I am aware of is calculate([Total Revenue], samepriodlastyear([dateextracted])). but I am not sure how do I split all three years from total revenue and then create 3 bars on chart to show (for 2014, 2015 and 2016). then add yoy growths for current and last year. 

3. I have saparated timestamp into date, time_buckets for 2 hours but when I drop the hour bucket into h-axis, it doesn't work.

Please find the link and chart to the file below. 

https://1drv.ms/u/s!An7xL0sD_E7PhWU4DD9ac6oveczL

Many thanks for help in advance.  

Best regards,

Jed

[technolog]

Can you please tell me if the problem is still relevant? If you managed to solve it in some way, please write here how you solved this problem. Then it will be possible to mark this problem as solved.

If not, it may make sense to ask the question again, thus confirming the relevance of this problem.