Forum Discussion

aganes's avatar
aganes
Frequent Visitor
7 years ago

Show Utilization Graph Calculated from Start and End Time

Hi PBI pros,   My company rents out rooms by the hour. I am trying to add a feature to my PBI utilization tracker that shows popularity by half-hour    We have a system that stores bookings with ...
Need Help
aganes's avatar
aganes
Frequent Visitor
7 years ago

Hi Anonymous and Anonymous,

 

Thank you for your responses. Please click here to find my sample data for the dashboard for the month of August 2018. There's a .pbix in import mode, and an Excel with the data for the three source tables.

 

I am trying to replicate what is currently the 'Popularity by Hour' bar graph on the 'Utilization Dashboard' tab, but captured with a measure rather than each column being a separate value column. I believe this is necessary so I can manipulate the data more intuitively (specifically removing zeros, sorting by value and using a 'Top 10 feature').

 

Please see the 'Popularity by Half-Hour' tab for some more context on how utilization is being captured in units.

 

Any help would be greatly appreciated!

All the best,

Alex

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi aganes ,

    I'd like to suggest you to do unpivot column on your time fields to convert records.

    Unpivot columns (Power Query)
    Then you can write formula to calculate based on unpivoted attribute and values.

    Regards,

    Xiaoxin Sheng