Conditional Formatting based on Max number in row - Matrix

[jcastr02]

I am trying to change the background color of the cell in each ROW of the highest number.  Example, In the second row, the 30% would change color to dark grey in background.  This is a matrix visual . Is there a DAX for this?

[amitchandak]

I assume Strongly Agree, Agree etc are part of on dim.

Create a measure to have max value at attribute level and use this measure to calculate color.

In the conditional formatting; for each column, go to advance control and choose field and this color measure.

[jcastr02]

@amitchandak would you be able to recommend a DAX, I am struggling there.  

[v-lili6-msft]

hi @jcastr02 

You could create a measure as below:

Ismax = IF( MAXX(ALLSELECTED('Table'[Response]),[Measure])=[Measure],1,0)

Note: [Measure] is the measure in your current matrix

Then do the conditional formatting as below:

Result:

and here is sample pbix file, please try it.

Regards,

Lin

[jcastr02]

Hi @v-lili6-msft    I don't have a measure in my current matrix - I am just taking a count of the responses and showing as % of total from row.  Will that be a problem?

[jcastr02]

Hello @v-lili6-msft   seems the measure is not working, I've added screen shots for your guidance

[v-lili6-msft]

hi @jcastr02 

[Attribute.1] is a Text value, you couldn't use SUM for it, you need use COUNT instead.

And if you still have the problem, please share a simple sample pbix file for us have a test. that will be a great help for this simple case.

Regards,

Lin

[jcastr02]

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

@v-lili6-msft   see the 30 day Feedback Tab, table is on bottom

[v-lili6-msft · Accepted solution]

HI @jcastr02 

I opened your file and it was my laptop that was very jammed and crashed,  your report is so big.please try this formula:

% of Attribute = divide(calculate(COUNTA('30 Day - Attribute'[Response])),CALCULATE(COUNTA('30 Day - Attribute'[Response]),FILTER(ALLSELECTED('30 Day - Attribute'),'30 Day - Attribute'[Attribute.1]=MAX('30 Day - Attribute'[Attribute.1]))))

Regards,

Lin

[v-lili6-msft]

hi @jcastr02 

You could just create a measure as below

This measure is the logic of 'showing as % of total from row':

Measure = DIVIDE(CALCULATE(SUM('Table'[Value])),CALCULATE(SUM('Table'[Value]),ALLSELECTED('Table'[Response])))

Regards,

Lin