Forum Discussion
Need help with conditional formatting
Hi Anonymous ,
One sample for your reference. Please check the following steps as below.
1. Insert an index column in power query.
2. To create a measure as below and set conditional formatting based on the measure.
Measure = VAR ind = MAX ( Table1[Index] ) + 1 VAR cal = CALCULATE ( MAX ( Table1[name] ), FILTER ( ALL ( Table1 ), Table1[Index] = ind ) ) RETURN IF ( MAX ( Table1[name] ) = cal && ind <> 2, "#01B8AA", "#000000" )Pbix as attached.
Super UserAnonymous it is not clear what you want to highlight when change what
does you want to highlight def as previous row it was abc, or you want to highlight 2 becuase it is changed from 1.
what if the value within same name changes?
read this post to get your answer quickly
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
I need to do this for each column. or each row. whatever works.
I need 'def' to be highlighted because it was 'abc' in the row right above it, and then I also need '2' to be highlighted as it was '1' in the row right above it.
So if this formatting is applied row-wise, meaning rowsare compared to each other and different values are highlighted, then that is good enough for me too.