Forum Discussion
Multi-column matrix color formatting
Hi!
I've create a matrix with multiple columns headers: Chemical, Level 1 and Level 2. The row headers are Location and Date, the values are results.
I've added a measure to conditionally format the results to color based on which Level it falls within - e.g:
>= Level 1 && < Level 2 = green
>= Level 2 = tan
I would like to color code the column headers reflect the above colors Level 1 (green) and Level 2 (tan) so that it is apparent to the viewer which Level is being applied. Unfortunately I cannot select individual column headers in the format section. Has anyone accomplished this before? is it even possible?
I've included a screen shot of the existing formatting and what I would like to accomplish below:
Please let me know if you have any questions/comments/concerns.
Thanks!
CJ
2 Replies
- amitchandakSuper User
Anonymous , As of now, you can not do conditional formatting on Row/column (Pivot) of Matrix Visual. You can only do it for values.
refer if needed
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3 - AnonymousNot applicable
Thanks Amitchandak.
Bummer...would be a nice option.
Am new to this community group, where can suggestions be made for future enhancements?
CJWash