Forum Discussion
Formatting
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?
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.
5 Replies
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
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.
