Forum Discussion

anjanikumar's avatar
anjanikumar
Helper III
11 months ago
Solved

Matrix visual issue !!

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 ?    
Need Help
  • v-venuppu's avatar
    v-venuppu
    10 months ago

    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's avatar
v-venuppu
Community Support
11 months ago

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.