1️⃣ Clean both sources.
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
@skillwave.training
@skillwave.training1️⃣ Clean both sources.
2️⃣ Replace "0:00:00" entries with nulls so empty records wouldn't clutter the #PivotTable.
3️⃣ Build shared employee and calendar tables
4️⃣ Write measures to calculate the variance.
@skillwave.trainingOr you can try driving the chart from #DynamicArrays so it works off worksheet formulas instead of a #PivotTable.
🧭Takeaway: If a PivotChart keeps breaking on refresh, change the foundation instead of fighting the formatting.
@excelguru.caDuring an AKA call, an attendee brought a stubborn #PowerPivot problem: how do you show a single “Total Units” column in your #PivotTable, but show forecasts monthly without either duplicating a #DAX measure every single month, or ending up with a wall of blank columns that have to be hidden? 🧵
@jalexandercohen.comStill more thoughts about scalable things: UIs, views, the benefits we get from going from one view to another (micro/macro).
The problem is that this view is like a #PivotTable. It's not immediately visible.
