Matrix - Dark Grey color with max number in each row

[jcastr02]

Trying to set up a cond formatting to the highest number in each row, to be background color of dark grey

[jcastr02]

Hello I have a Matrix visualization that I need to change the background color of the HIGHEST number in each row to grey.  What DAX formula can I use for this, please see below screen shots.  

[v-lid-msft]

Hi @jcastr02 ,

We can use the following measure as color field to meet your requirement:

Color = 
IF (
    SUM('Table'[Value])
        = MAXX (
            SUMMARIZE (
                FILTER (
                    ALLSELECTED ( 'Table' ),
                    'Table'[Attribute] IN FILTERS ( 'Table'[Attribute] )
                ),
                'Table'[Response],
                "Measure Value", SUM('Table'[Value]) )
        ,
            [Measure Value]
        ),
    "#808080",
    "#FFFFFF"
)

If it does not meet your requirement, could you please share the formula of measure you used in the value filed of the matrix visual if it does not contain any confidential information?

Best regards,

[jcastr02]

When I go to Cond. Formatting, the Measure I created is greyed out.  See below screen shot.  I see that you created another measure for the Values  area.  I currently just have mine set to a count and % of row.      Any ideas @v-lid-msft 

[mwegener]

Hi @jcastr02 

are there measures or columns in the Martix columns?

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[jcastr02]

Hi @mwegener , no there is not - just using % of row total in the values field  - see screen shot below 

[mwegener]

Hi @jcastr02 ,

check this out.

PBIX

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.

[jcastr02]

Hi @mwegener   Seems it's making all values as 1...can you take a look at file

https://1drv.ms/u/s!Ava_12t7CNJtkCGALXOtGpymk1pF 

https://1drv.ms/u/s!Ava_12t7CNJtkCGALXOtGpymk1pF

[v-lid-msft · Accepted solution]

Hi @jcastr02 ,

We can try to use the following measure as the field of condition format to meet your requirement(we have modify it from your last post, now it can be selected).

Attribute - Color = IF(count('30 Day - Attribute'[Response])=MAXX(summarize(filter(allselected('30 Day - Attribute'),'30 Day - Attribute'[Attribute.1] IN FILTERS('30 Day - Attribute'[Attribute.1])),'30 Day - Attribute'[Response],"Measure Value", COUNT('30 Day - Attribute'[Response])),[Measure Value]),"#808080","#FFFFFF")

 

Best regards,

[jcastr02]

@v-lid-msft thanks so much that worked, do you know what may be causing this to show as a light grey in this empty box?

[v-lid-msft]

Hi @jcastr02 ,

We can use the following meausre to solve this issue:

Attribute - Color = IF(count('30 Day - Attribute'[Response]) + 0 <>0, IF(count('30 Day - Attribute'[Response])=MAXX(summarize(filter(allselected('30 Day - Attribute'),'30 Day - Attribute'[Attribute.1] IN FILTERS('30 Day - Attribute'[Attribute.1])),'30 Day - Attribute'[Response],"Measure Value", COUNT('30 Day - Attribute'[Response])),[Measure Value]),"#808080","#FFFFFF"),"#FFFFFF")

If you have any other questions, please kindly ask here and we will try to resolve it.

Best regards,

[jcastr02]

Conditional Formatting in Matrix 

Is there a way to do a conditional format for the highest number in each ROW.  Looking to color it a dark grey color.  Thanks

[amitchandak]

The screenshot is small , not visible.

But create a rank on that group by. And then using constional fomatting color each column in drak green. Using Rank.

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

Or create even a measure on rank like

if ([RANK Meausre] =1, "green","white")

This can be used in conditional formatting , Advance control - Field

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[mwegener]

Hi @jcastr02 ,

check this PBIX

Regards,

Marcus

Dortmund - Germany
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.