Matrix visual issue !!

anjanikumar  

To show the Planned Need (FY) column only once in your Power BI Matrix visual, rather than repeating it across each tertial (T1, T2, T3), you can use a conditional measure to control its visibility. Here's how to fix it:

Solution: Use a Conditional Measure

Create a new measure that only displays the value once, based on the context. For example:

PlannedNeedFY_Single = IF( ISINSCOPE('DateTable'[Tertial]), BLANK(), [PlannedNeedFY] )

• ISINSCOPE('DateTable'[Tertial]) checks if the matrix is currently slicing by tertial.
• If it is, the measure returns blank.
• If not, it returns the actual value—so it appears only once, typically in the Total column.

Alternative: Show Only in One Tertial

If you want it to appear only in T3, for example:

PlannedNeedFY_T3Only = IF( SELECTEDVALUE('DateTable'[Tertial]) = "T3", [PlannedNeedFY], BLANK() )

This will show the value only under T3 and leave T1 and T2 blank.