Forum Discussion
Power Bi Table Visual formatting
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,
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 )
1 Reply
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 )