Forum Discussion
Formatting Column headers in matrix
Hello,
I've solved the problem and it's possbile :)))
In the Column Format tab, where you can set background or front color for one chose column, there you can set up that the format you want only apply for headers, and does not apply for values and totals maybe! This way I can chenge some specified column headers into another back color!!
Cheers,
Mate
As of November 2019 there is a method to format individual column headers.
1. Select the Matrix
2. In the Visualizations pane under the paint poller (Format) select Field Formatting
3. Select the column name from the dropdown
4. Select the background color
5. “Apply to Header” – On
6. “Apply to Values” - Off
thank you
Unfortunately that only works for fields in the "values" section. Any ideas how to change just 1 specific column background/formatting of a field that is in the Rows (confusing terminology by Microsoft right) without changing it for all the columns?
Kind of, ugh, select the format (paint roller) of your Matrix. Under the "Field Formatting" menu you can select your value and change the background. Then using the sliders below the background color option, you can turn on or off the color you selected to impact the header, values, or totals individually.
However, I have noticed if you only have one value loaded into your "Values" dimension, then it will change all columns in your table the same. Meaning, if you have a pivot and say dollars in the value, by months in the columns, they all change.
But in my case, my values are individual measures I have created, so my first column is volume, next is dollars, then cost, etc.... so when I go in as described above, I'm able to format each column individually. In my case I have to create individual column anyway, but it would be nive if it worked the other way to.
Not sure if this help you, but something I'd like to see changed as well.
Terry
Hi, thanks for your reply. I'm referring to the Rows not the Values. Indeed I know we can format the Values with option for subtotal/headers/values but that's all on that single Values item selected (in lightblue background below).
You see in the Field formatting you can only select the things you put in the "Values" which for me is only 1 item (OriginalCcy). I'm not able to select any items that have been put in the "Rows" section, and individually choose their background or font formatting.
