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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
v-tangjie-msft
Community Support
Community Support

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
v-tangjie-msft
Community Support
Community Support

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.