Forum Discussion
Remove Duplicates
Hi JofrainVisda
Unfortunately, we don't have an option to "merge cells" vertically as with Excel in tables.
So the scenario of hierarchial data should be presented with matrixes.
What kind of conditional formatting do you need to use?Hi JofrainVisda unfortunately as you mentioned you can only format the values.
The concept that you want, yet impossible.There is an idea about this issue you can vote for here:
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=b02bce75-4528-ec11-b76a-281878e62223i voted 🙂
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
Hello JofrainVisda ,
the table visual won't make it look as yoiu wantit, only a matrix can make it as you want.
Thank you for your quick response. If I use matrix, is there a way which I can put a conditional background color for each column?
JofrainVisda , refer to this article regarding conditional formatting to see what are all the possible options
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting
