Formatting

[jjoerger]

I have a viz which contains a table/many columns.  I want to highlight cells in a column where the value is the same as the value the row above/below it.  In this case a column not pictured here is common to both values needing to be highlighted.  In this example I have two dupes (4 cells) which would be highlighed.  Is this type of conditional formatting possible?

[jjoerger · Accepted solution]

A little more detail and still getting an error:

Otherwise I understand the example and I think I'm close.  I'm excited as it looks like from your example it's possible.

[matemusic]

As I know, it is a bit complicated: First you have to know an order of rows - months for example.

After that, you can create new measure, which look for previous and next month.

For example, i created a month table with month numbers and added some values for each month. Then i created a measure test, which returns one or zero if in next or previous month number is the same. After that you can create conditional formating based on measure Test.

Test = 
VAR mnth = min(Months[Month]) --Check which value is in current month, it can be also average, max...
VAR x = CALCULATE(sum(Months[Numbers]);filter(all(Months);Months[Month]=mnth-1))
VAR y = CALCULATE(sum(Months[Numbers]);filter(all(Months);Months[Month]=mnth+1))
VAR crrnt = sum(Months[Numbers])
RETURN if(x=crrnt || y = crrnt;1;0) //if previous or next month is the same, then return 1 else return 0

[jjoerger · Accepted solution]

A little more detail and still getting an error:

Otherwise I understand the example and I think I'm close.  I'm excited as it looks like from your example it's possible.

[v-frfei-msft · Accepted solution]

Hi @jjoerger,

Please try to change all the semicolon of your formula to comma.

Regards,

Frank

[matemusic]

Ups, Euro style 🙂

[jjoerger]

Thank you kindly