How to highlight every new high max value

Question

Hello Everyone,&nbsp;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:&nbsp;Table Name - Customer_WeightFields : Customer Name, Date, Weights&nbsp;Matrix table example&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan&nbsp; &nbsp; Feb&nbsp; &nbsp; Mar&nbsp; &nbsp;AprilCustomer 1&nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; 1Customer 2&nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp;10Customer 3&nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp;I want the result of the conditional format to show the following highlighted red&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; Jan&nbsp; &nbsp; Feb&nbsp; &nbsp; Mar&nbsp; &nbsp;AprilCustomer 1&nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; 8&nbsp; &nbsp; &nbsp; &nbsp; 1Customer 2&nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp;10Customer 3&nbsp; &nbsp; &nbsp; &nbsp;6&nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;4&nbsp; &nbsp; &nbsp; &nbsp; 3&nbsp;Any help would be great&nbsp;&nbsp;thanks again !!!&nbsp;

jihwan_kim · Accepted Answer

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.
&nbsp;

&nbsp;

&nbsp;
Weight measure: = 
SUM( Customer_weight[Weights] )
&nbsp;
&nbsp;
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" )

&nbsp;
&nbsp;

Forum Discussion

How to highlight every new high max value

2 Replies

Related content

Highlight duplicate values in a table

What are the highlighted values called?

Table Highlight in Desktop

Highlight clicked button

Custom Visual Highlighting/Selection stops working