Conditional Formatting - Table with Multiple Measures

[ronaldbalza2023]

Hi power bi friends. Could someone help me out on this one please. So I have a table with static data (5 years & 1 year column) and with different measures (YTD column)

I wanted to have a conditional formatting with the YTD column like data bar that says if YTD column is nearing to reach the 1 year column, the color will be turned into orange, then if YTD is nearing to reach the 5 year column it will then turned into green. Please note that the YTD column has different measures and value on it so I am not sure if right-clicking and set the conditional formatting would work. Thanks in advance!

See YTD column measures:

YTD Measure = IF (
    HASONEVALUE ( 'KPI Financial Planning'[Category] ),
    SWITCH (
        VALUES ( 'KPI Financial Planning'[Category] ),
        "$EBIT", [$EBIT Financial Planning],
	    "$Revenue", [$Revenue FP],
	    "Average Revenue/Client $", [Average Revenue/Client $],
	    "Client facing team members", [No. of Clients FP],
        "EBIT% of revenue", [EBIT% of revenue FP],       
        "Enterprise Value", [Enterprise Value FP],
        "No. of business locations", [No. of Business Locations],
        "No. of Clients", [No. of Clients FP],
        "No. of equity holders", [No. of equity holders],
        "Revenue per FTE", [Revenue per FTE FP],
        "Total FTE team", [Total FTE Team FP],
        "Turnaround Days", [Turnaround Days FP],
        0
    ))

[Anonymous · Accepted solution]

Hi  @ronaldbalza2023 ,

I created some data:

Here are the steps you can follow：

1. Create measure.

Measure =
QUARTER(MAX('Table'[date]))

2. Find [Measure] in Fields, and select Conditional formatting – Background color.

3. Enter the Background color interface, select Format by – Rules, and then set the conditions according to your needs.

4. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[ronaldbalza2023]

thanks very much 🙂