Remove/hide column on Matrix table

[Anonymous]

Hi, I have added a measure to my matrix table which calculates the percentage difference between the actual and the targeted amounts. Only issue is that this calculated value repeats against the actual and the target amounts - as per below.

I do not want this value to show against the Actual Amount (as highlighted) but only against the Target amount. For example, I'd like the Jul-19 first 2 rows to look like:

$0.03M     $0.02M    50.1%

$0.16M     $0.06M   150.5%

Is there a way that I can hide/remove the columns highlighted below? Thanks, Frank

[MFelix · Accepted solution]

Hi @Anonymous,

Yoi can reduce the size of the column until is fully hidden by dragging the column split as you do with the excel columns or row.

Just remember to turn off word wrap.

[peterhui50]

I ran into this situation today.

For all the columns you want to hide, it's overlapping with a column which a context in the column. You can exclude those by using the following

SWITCH(TRUE(),

CONTAINS(DateTable,DataTable[Year], "2019"), "", //indicating the value of the column you want to hide

Your_Measure)

Basically the idea is I want so say if that column in my matrix visual, in my case it was a year, I saying if it overlaps with year 2019 on the matrix visual, put nothing, else do the regular measure.