Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello Team,
I'm trying to customize the Subtotal in the Table/Matrix chart, please guide me through..
Below is the data, when I select Income and Other income Subtotal should display SUM of these two category values...
how ever If I select Expense along with Income then either subtotal should be masked or should be difference between
Income and Expense ..
the same follows with Income and Sales too..
To customize the subtotal in a Table/Matrix chart in Power BI, you can create calculated columns to represent the desired subtotals and then use them in the chart. Here's an example of how you could approach this:
Total Income = SUM(Table[Income] + Table[Other Income])
Income - Expense = SUM(Table[Income]) - SUM(Table[Expense])
Income - Sales = SUM(Table[Income]) - SUM(Table[Sales])
Note that this is just one example of how you could customize the subtotals in a Table/Matrix chart in Power BI. You can also use different DAX formulas or pivot the data to get the desired subtotals.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
172 | |
108 | |
105 | |
71 | |
70 |