Forum Discussion

ronaldbalza2023's avatar
ronaldbalza2023
Continued Contributor
5 years ago
Solved

Conditional Formatting - Table with Multiple Measures

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 conditiona...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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's avatar
    ronaldbalza2023
    Continued Contributor
    5 years ago

    thanks very much 🙂