highlight top N% in matrix with multiple rows and columns

[ashjas]

I have a matrix and I have a 3-row header - VP Name, Manager Name, Role

then I have a Column which has two headers - no of hours by each role and the total of their rate.

Under rate and total, I want to highlight top 15% value as we have it in excel ( Pivot tabl

[v-chenwuz-msft · Accepted solution]

Hi @ashjas ,

Please use Field value.

Create a measure like this:

Measure =
VAR _s =
    SUMMARIZE (
        FILTER ( ALLSELECTED ( 'Source' ), [Country] = "usa" ),
        [Sr Manager],
        [Manager],
        [Product],
        [Period Qtr],
        [Period Month],
        [Country],
        "sum", SUM ( Source[Sales] )
    )
RETURN
    IF (
        SELECTEDVALUE ( Source[Country] ) = "usa"
            && SUM ( Source[Sales] ) > PERCENTILEX.EXC ( _s, [sum], 0.75 ),
        "red"
    )

Result:

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

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

[ashjas]

Can someone please help?

[amitchandak]

@ashjas ,
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[ashjas]

Hi Please find attached.

Excel file has sample data

1.png shows how the solution can be implemented in excel.

2.png is the end result and I want to replicate the same in power bi