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.
Hello there,
is there a way to move grand totals to the top in a table without using hierarchys? I would like to apply to all tables in the report and creating that many hierarchies might not be that easy.
Solved! Go to Solution.
Hi @Anonymous ,
Find the visual as you shown above is Matrix visual but not a table visual. It is not supported to move the grand total to the top of table , or the top of Matrix visual without using hierarchy.
Please vote the idea https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19103272-table-matrix-total-column-on-first-position , to improve the Power BI Desktop.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future. We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
A good solution can be found in this post:
Solved: show grand totals top/bottom of matrix - Microsoft Power BI Community
Hi @Anonymous ,
Find the visual as you shown above is Matrix visual but not a table visual. It is not supported to move the grand total to the top of table , or the top of Matrix visual without using hierarchy.
Please vote the idea https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/19103272-table-matrix-total-column-on-first-position , to improve the Power BI Desktop.
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future. We also submitted this feedback to the product group internally, so that the product group can pay attention to this problem and speed up the issue repairing.
Best Regards,
Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have used as a workaround a number of small Card visuals aligned with the columns above the tables with no labels. This can work graphically also very well as you have the flexibility of the individual card settings. Gives you right away a summary like view above the table on the information. Use same filter for all related data, so numbers stay aligned when filtered.
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 |
---|---|
97 | |
95 | |
80 | |
77 | |
66 |
User | Count |
---|---|
130 | |
106 | |
105 | |
86 | |
72 |