cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mancunian Frequent Visitor
Frequent Visitor

Live performance dashboard.

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. Smiley Sad

 

Please find the link and chart to the file below. 

 

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

 

Many thanks for help in advance. Smiley Happy 

 

 

Best regards,derby_chart.png

Jed

 

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 367 members 3,980 guests
Please welcome our newest community members: