Power Bi Table Visual formatting

[Anonymous]

Hi,

I have a table visual as in the picture below. Is it possible to highligh which total (in yellow) is the lowest and/or highest?

Thank you,

[Jihwan_Kim · Accepted solution]

Hi,

I am not sure how your semantic model looks like, but I tried to create a sample pbix file like below.

Please check the below picture and the attached pbix file.

Cost total: = 
SUM(cost[cost])

INDEX function (DAX) - DAX | Microsoft Learn

Cost total lowest: = 
VAR _lowest =
    CALCULATE (
        [Cost total:],
        INDEX ( 1, ALL ( agent[agent] ), ORDERBY ( [Cost total:], ASC ) )
    )
RETURN
    IF ( [Cost total:] = _lowest, 1 )