Forum Discussion
Conditonal Formatting based on another column
I have a table where where we have licence number and expiration Date ,in the left slicer we select duration 60 days based on that we calculate wheather a license number is expired or not ,For supppose 37321 is 4 records out of which 3 is experied and 1 is renewed ,so we are showing renewal license number in green color and remaining in yellow and green .
But right now i want to show for a particular license number if it is renewal than it has to be in green,can some provide a slotion for this.I am blocked here.Thanks
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.
2 Replies
Can you share pbix file with mockup data, few records to understand datamodel.
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.
