Add value to powerbi matrix without making a new column
I have created a matrix with some transaction data. I want to display the monthly amounts as columns, but add a column at the end that shows average and target. When I add my measure which calcultes average, it adds it to every single month. Is there a way to display the column just at the end. Ideally it would look like this. Is it possible to add a column to a matrix without it adding it next to every month?
The easiest way is to hide the columns for [Average] in each of the months by dragging the field boundary, but you will need to turn off the "Word wrap" and possibly the "Auto-width" in the formatting options for columns in the formatting pane. If you need a more "complex" structure, you can create a custom layout. Here is a "tutorial" on how to achieve this: