Forum Discussion
Formatting only header fields in Matrix visual
Hi
I have a matrix visual as shown in image below . I want to give different/alternate background colour to only the header fields of the rows i.e Project name , Duration (in days) and Go Live date AS SHOWN IN THE image
I dont want any change in the values section i.e the gannt chart and month names
Is this possible. Really appreciate any help with this
Hi ashwinkolte ,
If you have created a Idea post sharing the link here would be helpful for other community members who may have similar feedback.
Please share the idea post link and accept that as solution so as to help other community members who may come accross this post in the future.
Thank you
11 Replies
Hi ashwinkolte,
Power BI Matrix visual natively doesn't support for row headder conditional formating but there is a workaround. Instead of Matrix chart you can use Table Chart and follow the below steps.
1. Go to the Specific Column(1) > Apply Setting to(2) > Select the specific/required column from Series(3) drop down > Enable the button Apply to headders(4) (By default it enables Apply to values make sure it should be turn off) > Select the Background color(5)
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.ajaybabuinturi Thanks for the reply . But this work around will apply one background colour to all rows of header. I want to give alternate row colours
The Specific column shows only field for values i.e the right hand part ....Just one field . It doesnt show header fields i.e the fields on the left
ashwinkolte, I believe your looking in the Matrix visual but I suggested Table visual. Please go through all steps as I mentioned in my previous response.
Thanks,
If you found this solution helpful, please consider giving it a Like👍 and marking it as Accepted Solution✔. This helps improve visibility for others who may be encountering/facing same questions/issues.I dont think I can use a table visual . I am showing a Gantt chart hence I want Year-month as different columns . Table colums will give me year-month values in a single column or else I will have add those columns manually . I want those columns to be addded dynamically when there is a new date falling in subsequent months .
Hi ashwinkolte ,
If the provided workaround by to modify the background colour is not working and If any alternate feature is important for your functionality Please consider sharing your suggestion in the Power BI Ideas forum
Fabric Ideas - Microsoft Fabric Community,
where the product team actively monitors user feedback. Ideas with strong community support are more likely to be considered for future implementation. Posting there helps ensure your request reaches the right audience and contributes to shaping the product roadmap.
Thank youSubmitted.
Hi ashwinkolte ,
If you have created a Idea post sharing the link here would be helpful for other community members who may have similar feedback.
Please share the idea post link and accept that as solution so as to help other community members who may come accross this post in the future.
Thank you
