Forum Discussion

subhendude's avatar
subhendude
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago
Solved

Highlight rows in a matrix table with a maximum value

I'm using a dataset as shown below. It contains the latency of different components across the locations. I'm using a matrix table with [Component] and [Location] field in Rows and [Latency] i...
Need Help
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    3 years ago

    Hi, subhendude ;

    You could create measures as follow:

    firstlocation = 
IF(ISINSCOPE('Location'[Location]),
   MAX('Data'[Location]),
   CALCULATE(MAX('Data'[Location]),FILTER('Data', 
     [Latency]=CALCULATE(MAX('Data'[Latency]),ALLEXCEPT('Data','Data'[Component])))))
    value = 
IF(ISINSCOPE('Location'[Location]),
    MAX('Data'[Latency]),
    CALCULATE(MAX('Data'[Latency]),FILTER(ALL('Data'),[Component]=MAX('Component'[Component]))))
    condition = 
VAR _max =
    CALCULATE ( MAX ( Data[Latency] ), FILTER(ALL('Data'),[Component]=MAX('Component'[Component])))
    return IF([value]=_max,1)

    The final show:


    Best Regards,
    Community Support Team _ Yalan Wu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
3 years ago

subhendude , You can only highlight the value, not row column, Assume latency  is a meausre

 

Create a measure

if(calculate(maxx(Summarize(Table,Table[Compnent], Table[location]), Table[latency]), filter(allselected(Table), Table[Compnent] = max(Table[Compnent]) && Table[location] = max(Table[location])  )) = [latency], "Yellow", "white")

 

use in conditional formatting using field value option

 

How to do conditional formatting by measure and apply it on pie?


https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3