Improvement Suggestion: Preserve Total Values and Column Height in Stacked Column Charts with Field Parameters Current Behavior: In Power BI, when using field parameters to switch dimensions in a stacked column chart (e.g., grouping by activity type, department, or location), both the total height of the column and the total value displayed can change—even if the underlying data remains constant. This is because Power BI only stacks the visible segments based on the selected parameter, which can lead to misleading visuals and totals. Why This Is a Problem: The total amount of hours for a given day can appear to change depending on the selected grouping, even though all rows (activities) are populated with planned hours. The height of the column changes with the number of visible segments, which visually misrepresents the actual total. This behavior differs from Excel, where stacked columns maintain consistent height and totals regardless of grouping. Suggested Improvement: Introduce a chart setting or toggle that allows users to: Preserve total values across parameter selections, ensuring that the sum of all segments remains accurate and consistent. Maintain consistent column height based on the true total, even if some segments are hidden or filtered out. This could be achieved by: Internally calculating the full total from the underlying data, independent of the field parameter. Offering a visual mode where the chart reflects the full total while optionally indicating which segments are currently visible. Benefits: Ensures data integrity and visual clarity for users interpreting totals. Aligns Power BI behavior more closely with Excel, reducing confusion and improving user trust. Supports more accurate reporting and dashboarding, especially in operational and planning contexts.
... View more