topic How to highlight every new high max value in DAX Commands and Tips

How to highlight every new high max value

DaxAssistance — Tue, 28 Mar 2023 18:01:58 GMT

Hello Everyone,

I have a matrix table that I would like to highlight every new instance of a new max on each row.(Going from left to Right)

Please see below:

Table Name - Customer_Weight

Fields : Customer Name, Date, Weights

Matrix table example

Jan Feb Mar April

Customer 1 4 2 8 1

Customer 2 5 8 2 10

Customer 3 6 5 4 3

I want the result of the conditional format to show the following highlighted red

Jan Feb Mar April

Customer 1 4 2 8 1

Customer 2 5 8 2 10

Customer 3 6 5 4 3

Any help would be great

thanks again !!!

Re: How to highlight every new high max value

Jihwan_Kim — Tue, 28 Mar 2023 18:19:42 GMT

Hi,

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

Please check the below picture and the attached pbix file.

I hope the below can provide some ideas on how to create a solution for your datamodel.

Weight measure: = SUM( Customer_weight[Weights] )

Color condition measure: = VAR _maxvalueuptocurrentmonth = CALCULATE ( MAX ( Customer_weight[Weights] ), WINDOW ( 1, ABS, 0, REL, ALL ( 'Calendar'[Year-Month sort], 'Calendar'[Year-Month] ), ORDERBY ( 'Calendar'[Year-Month sort], ASC ) ) ) RETURN IF ( [Weight measure:] = _maxvalueuptocurrentmonth, "Red" )

Re: How to highlight every new high max value

DaxAssistance — Tue, 28 Mar 2023 18:35:48 GMT

You're Amazing thank you so Much !!!!!