Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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.!An7xL0sD_E7PhWU4DD9ac6oveczL


Many thanks for help in advance. Smiley Happy 



Best regards,derby_chart.png



Super User
Super User

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.

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors