Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
How do I create subtotals for each time period using a grid? For instance, Actual vs Budget for each Quarter along with the Total for the year? I have managed to create a grid showing Budget vs Actual but have not figured out how to add the Variance. The data is coming from two different data sources.
Thank for your help!
Solved! Go to Solution.
You may try to add a calculated table and use measure.
You may try to add a calculated table and use measure.
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Check out the January 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 61 | |
| 49 | |
| 30 | |
| 25 | |
| 23 |
| User | Count |
|---|---|
| 128 | |
| 102 | |
| 57 | |
| 39 | |
| 31 |