Forum Discussion
Hiding YoY% Column in Matrix
Hi, I have a simple table with prior year and current year values. I have then used a quick measure to create a year over year % variance. On a matrix, I would like to show the following... ...
Hi sdjpaterson, there is a workaround for your issue.
Click on the matrix visual you've created. Then go to the formatting options for the matrix. Turn off word wrap for column headers, row headers and values. Then turn off auto-size column width. At last, drag the GBP val YOY% inside the year 2019 from right to left, till the column is hidden.
Check if this works.
Hi, thanks, this looks like it will work. Great, will give it a go.
I assume there is a better way to do all this via DAX also, I will look into that aswell.