Forum Discussion
Double Headings
Hi All,
Can anyone help me work out how to replicate the below in Power BI ? In the data set there is a column for Validated and then each row below will say which version, so V1, V2 etc - same for Pending and Clairifiction. Thanks very much 🙂
if they can help
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795Can you share sample data and sample output in table format?
Hello @EmmaLynch ,
Like what @harshnathani mentioned above, you can create a Matrix visual.
So what is the structure of your data?
If it's like below, simply place the "Status" column in the "Rows", "Action Type" and "Category" field in the "Columns", "Values" field in the "Values" field.
Type of action
Category
Values
State
Validated
V1
40
Rate increase
Slope
V1
234
Rate increase
Clarification
V1
80
Rate increase
Validated
V2
35
Rate increase
Slope
V2
222
Rate increase
Clarification
V2
76
Rate increase
Validated
V3
30
Rate increase
Slope
V3
167
Rate increase
Clarification
V3
55
Rate increase
Validated
V4
18
Rate increase
Slope
V4
49
Rate increase
Clarification
V4
11
Rate increase
Validated
V1
58
Completion
Slope
V1
43
Completion
Clarification
V1
32
Completion
Validated
V2
50
Completion
Slope
V2
33
Completion
Clarification
V2
22
Completion
Validated
V3
20
Completion
Slope
V3
12
Completion
Clarification
V3
11
Completion
Validated
V4
9
Completion
Slope
V4
2
Completion
Clarification
V4
9
Completion
Validated
V1
457
No action
Slope
V1
111
No action
Clarification
V1
20
No action
Validated
V2
300
No action
Slope
V2
100
No action
Clarification
V2
0
No action
Validated
V3
154
No action
Slope
V3
86
No action
Clarification
V3
0
No action
Validated
V4
144
No action
Slope
V4
65
No action
Clarification
V4
0
No action
Validated
V1
322
Not initiated
Slope
V1
345
Not initiated
Clarification
V1
76
Not initiated
Validated
V2
300
Not initiated
Slope
V2
321
Not initiated
Clarification
V2
29
Not initiated
Validated
V3
200
Not initiated
Slope
V3
269
Not initiated
Clarification
V3
25
Not initiated
Validated
V4
128
Not initiated
Slope
V4
240
Not initiated
Clarification
V4
19
Not initiated
Click the button in the red box above the matrix and it will have double headers.
Optionally, you can enable/disable the total values in Format.
More details can be found here.
If your data structure is not like what I mentioned earlier, you can publish some sample data. This way we can help you faster and more effectively.
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it more quickly.
3 Replies
- amitchandak
Super User
if they can help
column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905
https://community.powerbi.com/t5/Desktop/grouping-measure-results/td-p/456795Can you share sample data and sample output in table format?
Hi EmmaLynch ,
You can try a matrix visualization
https://www.youtube.com/watch?v=58a2rIV2nYg
https://www.burningsuit.co.uk/blog/2019/04/7-secrets-of-the-matrix-visual/
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)- Icey
Community Support
Hello @EmmaLynch ,
Like what @harshnathani mentioned above, you can create a Matrix visual.
So what is the structure of your data?
If it's like below, simply place the "Status" column in the "Rows", "Action Type" and "Category" field in the "Columns", "Values" field in the "Values" field.
Type of action
Category
Values
State
Validated
V1
40
Rate increase
Slope
V1
234
Rate increase
Clarification
V1
80
Rate increase
Validated
V2
35
Rate increase
Slope
V2
222
Rate increase
Clarification
V2
76
Rate increase
Validated
V3
30
Rate increase
Slope
V3
167
Rate increase
Clarification
V3
55
Rate increase
Validated
V4
18
Rate increase
Slope
V4
49
Rate increase
Clarification
V4
11
Rate increase
Validated
V1
58
Completion
Slope
V1
43
Completion
Clarification
V1
32
Completion
Validated
V2
50
Completion
Slope
V2
33
Completion
Clarification
V2
22
Completion
Validated
V3
20
Completion
Slope
V3
12
Completion
Clarification
V3
11
Completion
Validated
V4
9
Completion
Slope
V4
2
Completion
Clarification
V4
9
Completion
Validated
V1
457
No action
Slope
V1
111
No action
Clarification
V1
20
No action
Validated
V2
300
No action
Slope
V2
100
No action
Clarification
V2
0
No action
Validated
V3
154
No action
Slope
V3
86
No action
Clarification
V3
0
No action
Validated
V4
144
No action
Slope
V4
65
No action
Clarification
V4
0
No action
Validated
V1
322
Not initiated
Slope
V1
345
Not initiated
Clarification
V1
76
Not initiated
Validated
V2
300
Not initiated
Slope
V2
321
Not initiated
Clarification
V2
29
Not initiated
Validated
V3
200
Not initiated
Slope
V3
269
Not initiated
Clarification
V3
25
Not initiated
Validated
V4
128
Not initiated
Slope
V4
240
Not initiated
Clarification
V4
19
Not initiated
Click the button in the red box above the matrix and it will have double headers.
Optionally, you can enable/disable the total values in Format.
More details can be found here.
If your data structure is not like what I mentioned earlier, you can publish some sample data. This way we can help you faster and more effectively.
Best regards
Icey
If this post helps,then consider Accepting it as the solution to help other members find it more quickly.
