Conditional Formatting Between Two Tables, Two Different Parameters

Nicole Barry
Nicole Barry
Tenth Anniversary Name Dropper Participant Facilitator 1
in SKY Developer General Discussions

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.

2e9ee680a9c008546ff5484e0ee859a9-huge-im
Tagged:

Comments

  • Alex Wong
    Alex Wong Community All-Star
    Tenth Anniversary Kudos 5 Facilitator 4 bbcon 2025 Attendee Badge

    @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
    Nicole Barry
    Tenth Anniversary Name Dropper Participant Facilitator 1

    @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.


Categories