cancel
Showing results for
Did you mean:

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Monthly Update - August 2024

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

Fabric Community Update - August 2024

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

Top Solution Authors
Top Kudoed Authors