Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to 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.
Hi @jjoerger,
Please try to change all the semicolon of your formula to comma.
Regards,
Frank
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.
Hi @jjoerger,
Please try to change all the semicolon of your formula to comma.
Regards,
Frank
Thank you kindly
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
85 | |
84 | |
67 | |
63 | |
62 |
User | Count |
---|---|
208 | |
121 | |
112 | |
79 | |
71 |