Conditonal Formatting based on another column

Hi Rkrama ,

Based on your description, it appears that you would like to highlight a specific license number in green if it is renewed. You can accomplish this by following the steps below:

1.Create a new metric to count the number of renewals for each license number.

Renewals = CALCULATE(COUNTROWS(Table1), Table1[License Status] = "Renewed")

2.Add a new column to the table to check if the license number is renewed.

Renewed = IF(Table1[License Status] = "Renewed", "Renewed", "Not Renewed")

Add a new conditional formatting rule to the table to highlight the row with the renewed license number. You can create this rule using the following steps:
Select the column containing the renewal status and click the Conditional Formatting button in the Visual Effects pane. Select Background Color as the format type. Select Color by rule as the formatting option. Select Field Value as the base field. Select "is" as the operator. Enter "Renewed" as the value. Select the color green for the background.

How to Get Your Question Answered Quickly - Microsoft Fabric Community

If it does not help, please provide more details with your desired out put and pbix file without privacy information.

Best Regards,

Ada Wang

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