This time we’re going bigger than ever. Fabric, Power BI, SQL, AI and more. We're covering it all. You won't want to miss it.
Learn moreLevel up your Power BI skills this month - build one visual each week and tell better stories with data! Get started
I have two tables, one for budget, one for actuals.
Both tables have sales and profit.
I want to create a Power BI table which has the columns - Sales... Profit
I want to have the rows as Actuals, Budget, Versus budget
So
.......................Sales............Profit
Actual.............. X...................X
Budget............ X...................X
vs Budget....... X...................X
Whats the cleanest way of creating this please?
Do i need to create new tables? What DAX measures should I create?
Any help would be amazing.
Thanks so much
This is great, but I'm not sure it works exactly for me. As I understand, calculation groups can be used for creating e.g. a YTD filter against any metric that you choose.
So you can select e.g. Sales, or Profit, and it would provide your time filter.
However, in my example, I have Sales and Profit actuals in one table, and Sales and Profit Budget in another table. And I want to compare the actuals to the budget for both metrics.
Does that make sense? Or perhaps I've not understand calculation groups properly.
THanks for your help
@colverjustin , i think calculation groups can help
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
Check out the April 2026 Power BI update to learn about new features.
Sign up to receive a private message when registration opens and key events begin.
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
| User | Count |
|---|---|
| 36 | |
| 29 | |
| 29 | |
| 21 | |
| 18 |
| User | Count |
|---|---|
| 69 | |
| 39 | |
| 33 | |
| 24 | |
| 23 |