Interesting experiments with Power BI.
After setting the correlation between a Revit space schedule and an Excel sheet with calculated heating & cooling loads, i’ve created synoptic panels for the two levels of the building, both for cooling and heating loads.
Refreshing the data ensures a consistent result with the latest version of the Excel file and the Revit schedule.