Forum Discussion
Remove/hide column on Matrix table
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 actu...
- 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.
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.
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.
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 hideYour_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.
