Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

0

Matrix Visual shows subtotals in values when multiple fields in columns despite subtotals turned off

When using multiple fields in the columns section of a matrix visual, it shows the value of the total for the previous higher level column category, but without the column displaying the word "total" in the header of the visual.  Instead the first level column category continues in sequence and therefore the data value under the column header is incorrectly showing a total and not the real value for the text header being indicated.  The real value is moved to the next column and therefore is also incorrectly labelled, which continues throughout the rest of the visual.

 

In my example if you have "Days" in columns, then add "Weeks" above the first value of the second week shows the first week's total, and the first day of the second week's value shows under the second day - all of the data values are pushed along by 1 column.  This means values do not match to the days labelled above in the header as they continue in sequence with no indication of "total" column headers.

 

Column subtotals is toggled to off by default.  Toggling column subtotal on then back off shows the data correctly as a workaround.

 

In my opinion the column subtotal values should not be displayed if the column subtotal switch is toggled to off (default position), but if the subtotals are added in to the visual by placing multiple fields to Columns section, then the "total" column header has to be displayed also.

Status: Delivered
In my opinion the column subtotal values should not be displayed if the column subtotal switch is toggled to off (default position), but if the subtotals are added in to the visual by placing multiple fields to Columns section, then the "total" column header has to be displayed also.

Currently when disabling total values in matrix, all hierarchies of matrix would not show the total value, it is by design in Power BI Desktop.

 

If you want to show total column header when adding new columns in matrix, perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/ideas/


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.

 

Best Regards,
Community Support Team _ Yingjie Li

Comments
v-yingjl
Community Support
Status changed to: Delivered
In my opinion the column subtotal values should not be displayed if the column subtotal switch is toggled to off (default position), but if the subtotals are added in to the visual by placing multiple fields to Columns section, then the "total" column header has to be displayed also.

Currently when disabling total values in matrix, all hierarchies of matrix would not show the total value, it is by design in Power BI Desktop.

 

If you want to show total column header when adding new columns in matrix, perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner: https://ideas.powerbi.com/ideas/


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.

 

Best Regards,
Community Support Team _ Yingjie Li

Anonymous
Not applicable

Thanks for the reply,

"Currently when disabling total values in matrix, all hierarchies of matrix would not show the total value, it is by design in Power BI Desktop."

 

The bug I am reporting is the fact that the total values are shown.  😞