Forum Discussion
Adjust Formatting for different Row Levels
Hi Anonymous,
Since you are looking for a creative workaround, here are few ideas that can help you create the desired colour variation where top-level rows (like "Sales" or "Procurement") have a different colour background.
* You can use a Custom Column for styling. First add a column to the data model that identifies the hierarchy level "RowLevelType = IF(ISBLANK([Subdepartment]), "Department", "Subdepartment")". Then use this field in a conditional formatting rule for background color (only partially effective, it won’t change the row header's background).
* You can also overlay with a Shape or Rectangle (in report design). If the matrix is static, consider overlaying a dark blue rectangle behind the department row using layers in Power BI canvas to simulate the background.
This is a manual solution, not dynamic.
* You can also use a Third-Party Custom Matrix Visual. Some custom visuals available on AppSource allow more granular styling control for different row levels.
Example: KPI Matrix, Zebra BI Table, etc.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team
Hello Anonymous,
since I did not find a option how to do it, I already assumed that I need some kind of creative workaround. That is the reason why I am writing in this community - to find someone who can help me with a nice workaround.
Thanks for answer!
Best
Hi Anonymous,
Since you are looking for a creative workaround, here are few ideas that can help you create the desired colour variation where top-level rows (like "Sales" or "Procurement") have a different colour background.
* You can use a Custom Column for styling. First add a column to the data model that identifies the hierarchy level "RowLevelType = IF(ISBLANK([Subdepartment]), "Department", "Subdepartment")". Then use this field in a conditional formatting rule for background color (only partially effective, it won’t change the row header's background).
* You can also overlay with a Shape or Rectangle (in report design). If the matrix is static, consider overlaying a dark blue rectangle behind the department row using layers in Power BI canvas to simulate the background.
This is a manual solution, not dynamic.
* You can also use a Third-Party Custom Matrix Visual. Some custom visuals available on AppSource allow more granular styling control for different row levels.
Example: KPI Matrix, Zebra BI Table, etc.
If I misunderstand your needs or you still have problems on it, please feel free to let us know.
Best Regards,
Hammad.
Community Support Team