Use different colors for different row levels in a matrix

[Anonymous]

When using the drill-down feature in a matrix, is there a way that I can use different colors for different row levels? For example, in this matrix, I'd like the State to be light gray, the Year to be dark gray, and have the rows of the lowest level, the Lead, alternate white and green. Is there a way to do that?

[v-frfei-msft]

Hi @Anonymous ,

Based on my test, we cannot get the excat same result as you excepted. However we can create a measure and make the filed formatted by the measure to work around.

Measure 2 =
IF (
    ISINSCOPE ( Table1[Year] )
        && ISINSCOPE ( Table1[name] ) = FALSE (),
    "#FF009B",
    IF (
        ISINSCOPE ( Table1[State] )
            && ISINSCOPE ( Table1[Year] ) = FALSE (),
        "#374649",
        "#F0E2FF"
    )
)

[Anonymous · Accepted solution]

Thanks. This doesn't help here because I need the entire row highlighted, including the row header, to which I can't apply conditional formatting. But it sounds like that isn't possible in the current edition of Power BI.

[v-frfei-msft]

Hi @Anonymous ,

You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas