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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
APM
Helper I
Helper I

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

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.

APM_0-1704989716184.png

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

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

vtangjiemsft_0-1705028463306.png

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])

vtangjiemsft_3-1705028833531.png

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())

vtangjiemsft_2-1705028769411.png

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. 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

vtangjiemsft_0-1705028463306.png

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])

vtangjiemsft_3-1705028833531.png

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())

vtangjiemsft_2-1705028769411.png

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. 

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.