Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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?
Solved! Go to 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.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
75 | |
60 | |
37 | |
33 |
User | Count |
---|---|
102 | |
56 | |
52 | |
46 | |
40 |