double heading of a column in a Matrix visual

[Anonymous]

Hi All,

Is it possible to have a double heading of a column in a Matrix visual?

Here, my requirement is to separate out all my Functional Fields and Planning fields in the matrix below to distinguish the fields.

(In the columns, all are separate measures have been added).

I can see it in 2 ways:

1. Eithera all Sub fields should have another main heading called "Functional Fields" and "Planning Fields".

Here, I just added extra descriptive Prefix to each fields to distinguish them as Functional or  Planning fields.

2. I also tried to customize the background color of the column header , so that I can separate out all Functional fields and planning fields with different background colors of the Header. But that option also I dont see in the tool.

TIA

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You can use a Text Box just above your Planning and Functional fields in matrix having values like - Functional/Planning.

Resize the text boxes in width to be shown above only relevant fields.

Thanks,

Pragati

[FarhanAhmed · Accepted solution]

Go to Field Formatting change the background color and just below it turn on "Apply to Header" and Turn off "Apply to Values"

that will separate your planning and functional columns

[Pragati11 · Accepted solution]

Hi @Anonymous ,

You can use a Text Box just above your Planning and Functional fields in matrix having values like - Functional/Planning.

Resize the text boxes in width to be shown above only relevant fields.

Thanks,

Pragati

[amitchandak]

@Anonymous , you added pre-fix to a column name or dimension values ?

Can you share sample data and sample output in table format?