Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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!
Solved! Go to Solution.
Hi @AtomChewacka,
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
Hi @AtomChewacka,
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 Pabbu
Dear @v-vpabbu !
That's the exact problem what i'm searching the solution for... as you can read before, i know the facts what you would like to exchange on kudos...
So sorry, but i can't accept your you r solution, because it isn't a solution...
Regards
Hi @AtomChewacka,
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
Dear @v-vpabbu !
I don't want to be rude, but yes, thats why i asked if somebody has already seen a visual like this... built in or downloaded or anything else... maybe writen and coded by someone in a "Deneb" visual...
I think the problem is already known since a long time, and if there is still no solution, my feedback won't help.. but ok thank you for the recommendation, i will try it.
Regards
Hi @AtomChewacka,
As we haven't heard back from you, we are closing this thread. If you have any further issues, please start a new thread in the community forum, and we will be ready to assist you. Thank you for being part of the Microsoft Fabric Community.
Regards,
Vinay Pabbu
User | Count |
---|---|
84 | |
77 | |
76 | |
43 | |
36 |
User | Count |
---|---|
109 | |
56 | |
52 | |
48 | |
43 |