cancel
Showing results for
Did you mean:

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Regular Visitor

## highlight top N% in matrix with multiple rows and columns

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

1 ACCEPTED SOLUTION
Community Support

Hi @ashjas ,

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.

4 REPLIES 4
Community Support

Hi @ashjas ,

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.

Regular Visitor

Super User

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

Regular Visitor

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

Announcements

#### Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

#### Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

#### Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors