Conditional Formatting Between Two Tables, Two Different Parameters

Nicole Barry

Ok forgive my being a novice and maybe biting off more than I can chew.

I was asked to create tables showing comparison giving from year to year.

The coding is being done based off appeals as we institute them numerically.

So in power bi i have one table showing amount raised on specific filters for appeals starting in 2023 (as well as other information)

In another table I have the same parameters, but adjusted the filter to show only 2022 appeal.

What I would like to accomplish is instituting a conditional format where:
If 2023 Appeal Total is Greater than 2022 Appeal Total, then “green”

My table is set up as follows:

Columns:

Fund ID Total Raised

Rows:

Each fund

Filter: Appeal ID starts with YYYY

I moved my data into excel for data protection to convey how it's set up.

Thank you in advance.

Alex Wong

@Nicole Barry
I don't believe you can conditional format based on multiple columns/measures of information. So you will have to first come up with 1 “piece” of info. If calculated column or measure will depend on your model.

You will want to setup a column/measure that you can “conditional rule on”. For example, maybe 2023-2022 and call it YOY Delta. Then conditional rule on this column/measure for IF YOY Delta is > 0, positive means 2023 is greater than 2022, then green. additional format 0 as black and negative (< 0) as red if you want.

Nicole Barry

@Alex Wong; thank you I had imagined I couldn't do it the way I envisioned. I'll try to figure out the steps you conveyed. They ideally want a Favorable/Unfavorable column so I can try to use that as my measure/ conditional formatting. I just have to figure out how to create it, using your reference above.