Skip to main content

Power BI

New

Matrix Visual text fields should be blank when rows are grouped

Vote (4) Share
HAROLD SCHIRMER's profile image

HAROLD SCHIRMER on 19 Apr 2023 22:22:50

I have a Power BI Matrix visual with two fields defined in the Rows section in the data pane. Several values are defined in the Value section of the data pane. The fields in the data pane include both numeric measures and text fields. I suggest that when a row header is collapsed, by pressing the +/- icon, that text fields become blank in the header row. Numeric measures can continue to display aggregated totals as today.


Today, when rows are grouped, numeric measures calculate correctly at the grouped level, but text fields show with the First or Last functionality. First or Last is meaningless when rows are grouped. In grouped rows text fields defined in the values section should be blank. Or there should be a configuration option to display a blank in the collapsed row.


Comments (1)
HAROLD SCHIRMER's profile image Profile Picture

Johnny Danko on 20 Apr 2023 12:48:49

RE: Matrix Visual text fields should be blank when rows are grouped

I am also having this issue with a number of my dashboards.