Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I am trying to add sum of values in a table for my income statement.
below every group I am trying to add a SUMof values above.
The colums groupbreak have a unique combination for each group.
I am not sure how to use these.
Solved! Go to Solution.
Hi @ahsanlhcgov
I would recommend using Matrix visual instead of Table, then you will have required aggregations.
Regards.
Pavel
Maybe I don't understand clearly what you want, but what about pic below? Isn't it what you want?
Regards.
Pavel
Hi @ahsanlhcgov
I would recommend using Matrix visual instead of Table, then you will have required aggregations.
Regards.
Pavel
i have tried the matrix visual but its the same thing. rather then adding the groups it shows the individual value as total.
I am looking for a way to categorize the group break values and then adding ActualYTD and BudgetYTD.
If I get that then which ever visual I use will work.
Maybe I don't understand clearly what you want, but what about pic below? Isn't it what you want?
Regards.
Pavel
I have created a new column and concatenated all the froup breaks and used that as a filter in matrix. Thanks alot for advising to use the correct visual.
Do you need help?
yes like that.
but I have 4 groupbreak colums which work as a unique identifier to determine the category needed to be summed up.
how did you do that, may be I can try to do the same on my data set.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |