Forum Discussion

fdkza's avatar
fdkza
Frequent Visitor
8 years ago
Solved

Determine Minimum and Maximum Value in Row in Matrix

Hi    I am relatively new to power bi   I have a dataset that looks as follows    Country Supplier  Value  A Acme 10 A Illuminati 12 A Batman 14 B Acme  20 B Illumi...
Need Help
  • Zubair_Muhammad's avatar
    Zubair_Muhammad
    8 years ago

    fdkza

     

    Hi,

     

    You can use a MEASURE to do the conditional formatting

     

    Measure =
VAR mymin =
    CALCULATE ( MIN ( Table1[Value] ), ALL ( Table1[Supplier ] ) )
VAR mymax =
    CALCULATE ( MAX ( Table1[Value] ), ALL ( Table1[Supplier ] ) )
RETURN
    SWITCH (
        TRUE (),
        SUM ( Table1[Value] ) = mymin, "#FF7F00",
        SUM ( Table1[Value] ) = mymax, "#2AAAFF"
    )

     

    Now in the Conditional Formatting dialogue

    Select as follows

     

     

fdkza's avatar
fdkza
Frequent Visitor
8 years ago

Hi 

 

I would like to display a seperate matrix or table layed out as follows 

 

SupplierLowest Values Highest Values Total Values 
Acme 213
Batman113
Illuminati 013
Zubair_Muhammad's avatar
Zubair_Muhammad
Icon for Community Champion rankCommunity Champion
8 years ago

fdkza

 

You can add these calculated columns

Please see revised file as well

 

Highest =
VAR temp =
    MAXX ( FILTER ( table1, [Country] = EARLIER ( Table1[Country] ) ), [Value] )
RETURN
    IF ( [Value] = temp, 1 )

Lowest =
VAR temp =
    MINX ( FILTER ( table1, [Country] = EARLIER ( Table1[Country] ) ), [Value] )
RETURN
    IF ( [Value] = temp, 1 )

  • arvindyadav's avatar
    arvindyadav
    Icon for Post Partisan rankPost Partisan
    7 years ago

    Hi Zubair_Muhammad ,

     

    In my case, the conditional format measure is not working while I am putting that measure in conditional format field value.

    Thanks,

    Arvind