Excel Pivot Tables: Two Fixes for Reports You Rebuild
Most pivot table pain comes from two setup choices nobody mentions. Here is how to build on a Table so a refresh picks up new rows, and how to let Show Values As handle your percentages.
-
-
Power BI for Excel Users: Two Steps to Your First Dashboard
Two concrete steps that take an Excel user from never having opened Power BI to a working, refreshable dashboard: clean the data in Power Query, then build visuals that one slicer drives.
End of content
End of content