Forum Discussion
Conditional formating of hierached rows in matrix
Hi everyone!
I have an issue to solve, please help me!
If there is some kind of visual or practice for conditional formating a hierarchical presented table.
The basic table visual gives you the opportunity to format the rows by data... but not hierarchical...
The basic matrix visual gives you the opportunity to present the hierarchy but you can only format the value columns...
I would mix it and i would like to format the datas and the rows of it too...
It is a payment and technical comletition issue...
All the completition datas are coming from other databases, and are dates... the completition of all preconditions are not equal too complete the TMS.
So i would like to format only by the values...
like this:
| hierarch | Completition | ||||
| TMS | TMS | PMS | |||
| PMS1 | no | ||||
| PMS1 | TMS 1 | yes | |||
| PMS1 | TMS 1 | Precondition 1 | yes | ||
| PMS1 | TMS 1 | Precondition 2 | yes | ||
| PMS1 | TMS 1 | Precondition 3 | yes | ||
| PMS1 | TMS 2 | no | |||
| PMS1 | TMS 2 | Precondition 1 | yes | ||
| PMS1 | TMS 2 | Precondition 2 | no | ||
| PMS2 | no | ||||
| PMS2 | TMS 3 | no | |||
| PMS2 | TMS 3 | Precondition 1 | no | ||
| PMS2 | TMS 3 | Precondition 2 | yes | ||
| PMS2 | TMS 3 | Precondition 3 | no | ||
| PMS2 | TMS 4 | yes | |||
| PMS2 | TMS 4 | Precondition 1 | yes | ||
| PMS2 | TMS 4 | Precondition 2 | yes | ||
| PMS2 | TMS 5 | no | |||
| PMS2 | TMS 5 | Precondition 1 | no | ||
| PMS2 | TMS 5 | Precondition 2 | no | ||
| PMS2 | TMS 5 | Precondition 3 | yes |
Thank you if you have some solution or proven visual... the best would be a free visual...
Thx!
Hi Anonymous,
There is currently no built-in Power BI visual that supports both true hierarchical rows and conditional formatting on those row headers within the same visual.
This is a known limitation in the Power BI ecosystem and and honestly, a popular feature request is required.I suggest submitting your detailed feedback and ideas through Microsoft's official feedback channels, such as Microsoft Fabric Ideas. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
https://ideas.fabric.microsoft.com/ideas/search-ideas/Regards,
Vinay Pabbu
5 Replies
Hi Anonymous,
Thank you for reaching out to Microsoft Fabric Community Forum.
The default Matrix visual in Power BI supports hierarchies well, but conditional formatting is limited to value fields, not row headers.
On the other hand, the Table visual allows row-level formatting but doesn’t support hierarchical structures.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Vinay PabbuHi Anonymous,
There is currently no built-in Power BI visual that supports both true hierarchical rows and conditional formatting on those row headers within the same visual.
This is a known limitation in the Power BI ecosystem and and honestly, a popular feature request is required.I suggest submitting your detailed feedback and ideas through Microsoft's official feedback channels, such as Microsoft Fabric Ideas. Feedback submitted through these channels is frequently reviewed by the product teams and can contribute to meaningful improvements.
https://ideas.fabric.microsoft.com/ideas/search-ideas/Regards,
Vinay Pabbu