Add color in row for PowerBI matrix

[pang22]

Hello,

I made a color in Excel pivot table for Country and Factory.

In PowerBI matrix, how to add the color for Country and Factory resoectively?

PowerBI matrix:

Country: CN

Facctory: QN

Excel pivot table:

[Anonymous]

Hi,

Thanks for the solution Uzi2019 offered, and i want to offer some more information for user to refetr to.

hello @pang22 , you can consider to use the conditional formatting for it, you can refer to the following solution.

Create a measure.

Measure = SWITCH(TRUE(),ISINSCOPE('Table'[Factory]),"grey","pink")

Then put it to the background color in conditonal formatting of the value.

Outptut

But please notice that when you expand it , the color of subtotal for each level will return the default value.

After testing, it cannot set the color for the subtotal for each level by condition. 

Best Regards!

Yolo Zhu

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

[Uzi2019]

Hi @pang22 

Check below video for better understanding

https://www.youtube.com/watch?v=wTRrskQzAHk

https://www.youtube.com/watch?v=FSTiPm5tY8A

https://www.youtube.com/watch?v=WF7fCAmjjZc

I hope above videos would help you to do formatting row wise.