Remove Duplicates

[JofrainVisda]

Hello friends,

I would like to ask for your help to remove the duplicates value in the first column without using the matrix visual. Because I can't put conditional background color with the matrix visual. But if you could also help me with that option, I will appreciate it.

It should look like this. I got it using the matrix visual, but again I can't put a conditional background color.

[Ritaf1983 · Accepted solution]

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?

[Ritaf1983 · Accepted solution]

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?

[JofrainVisda]

Hi Rita,
I would like to use the Conditional Background and font color. So I want the whole rows and columns of Business service excellence should have background color green, the whole rows and columns of One Manila Projects should be yellow. And percentage font color should be red or green if it hits the target.

[Ritaf1983 · Accepted solution]

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-281878e62223

i voted 🙂

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Idrissshatila]

Hello @JofrainVisda ,

the table visual won't make it look as yoiu wantit, only a matrix can make it as you want.

[JofrainVisda]

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?

[Idrissshatila]

@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