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.

anjanikumar , You need to create a calculation group there we can control if we want to details for a measure or not 

You can check if value isisnscope 

code of calculation group item 
if(isinscope(Table[Cate]), blank(), [Planned Need(FY)]) 

The second calculation item will simply have the measure 

example : https://www.youtube.com/watch?v=Eh4wJtGjSEE

Hi anjanikumar ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you amitchandak anilgavhane for the prompt response.

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

Hi anjanikumar ,

To stop Planned Need (FY), Need Change Ratio, and Need Share Ratio from showing again in Totals,you can try below:

PlannedNeed_NoTotal =
IF (
NOT ISINSCOPE ( 'DateTable'[Tertial] ),
BLANK(),
[PlannedNeed]
)

This ensures the measure only appears when the matrix is at the Tertial level, and stays blank at column totals.

Apply the same pattern to Need Change Ratio and Need Share Ratio.If you’re using calculation groups, you can use the same ISINSCOPE check inside the calc item.That way, your tertial-level columns stay visible, but they won’t repeat in the Total column.

Thank you.

Hi anjanikumar ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

Hi anjanikumar ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

Hi anjanikumar ,

As requested earlier, can you please share the samle data.

Thank you.