Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
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
Proud to be a Super User!
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
Proud to be a Super User!
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
@Anonymous , you added pre-fix to a column name or dimension values ?
Can you share sample data and sample output in table format?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |