Matrix visual issue !!

[anjanikumar]

In this visual Planned Need(FY) column was showing 3 times tertial wise, but i need only one time to show that , How to fix this in matrix visual ?

[v-venuppu]

Hi @anjanikumar ,

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

Thank you.

[v-venuppu · Accepted solution]

Hi @anjanikumar ,

Can you please share the sample data along with expected output, so that it will be helpful for us to solve the issue.

Thank you.

[v-venuppu]

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.

[anjanikumar]

issue not resolved 

[v-venuppu]

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.

[v-venuppu]

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.

[v-venuppu]

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.

[amitchandak]

@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

[anjanikumar]

when ever column sub total is enabled again some columns repeating in Total Level (Palnned Need, Need change Ratio , Need Share ratio basis Range status )which are not required , how to remove it in Totals without effecting  same columns in Tertial level ?

[anilgavhane]

@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.