Repeated columns in Matrix visual that I only need displayed once: how do I fix?

[APM]

In the Matrix visual, I have a few value fields that contain the same values for all column values. 

Sorry, I had to anonymize the data, but essentially, the columns I highlighted in yellow are repeated over and over for every column value. Ideally, that data would appear just once on the right, like the Style information does. I can't put that data in the rows with the style, upc, and size because these are measures.

Does anyone know of any way to customize a table such as this?

[Anonymous · Accepted solution]

Hi @APM ,

This is a design behavior for matrix visual objects. 

You can post your idea to Ideas .  https://ideas.powerbi.com/ideas/

You can use the following instead.
This is my current matrix.

If you want the measure to be displayed only on the rightmost side (at the total), then you can create another measure2 to be placed on the matrix instead of the measure.

Measure 2 = IF(ISINSCOPE('Table'[type]),BLANK(),[Measure])

If you want the measure to be displayed only on the far right (where the type is b3 in my example), then you can create another measure3 to place on the matrix instead of the measure.

Measure 3 = IF(SELECTEDVALUE('Table'[type])="b3",[Measure],BLANK())

Or you can make the MEASURE invisible by creating a graphic mask that is the same color as the background color or by manually adjusting the column width.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly.