Forum Discussion
Hide a column in a matrix
Hey there, I am deeply sorry to post this issue, wich has been solved many times but the solutions proposed don't work with me... I created a measure to calculate the evolution of 'Mandat...
Hi tdurieux,
There is no such an visibility option that supports to conditionally hide/show column in Matrix. One option is to hide or show the values in the column by creating measures, but column headers are still appeared even there is no data. Reference: https://community.powerbi.com/t5/Desktop/How-can-i-hide-Column/td-p/110087
Regards,
Yuliana Gu
Put the column you want to hide and the end of your matrix.
In the field formatting, give the column the same colour as the background, apply also it to the column header and total.
I have done it with a calculated column with a row title of 1 character and values 1 and 0, so the column is small in the view.