Forum Discussion
To apply calculated field
Hi
I have three column in backend 1) start date 2) end date and 3) calcultaed column created which captures todays date
i have created a column validatedFlag where applied a condition where if (datesbetween(currentdate,startdate,endDate),"X","") now I want to apply a conditional formating (icon) in front end on validatedFlag column like where the value will be X i need red cross icon and where there is blsnk value i need green circle. How to achieve?
Hi skaul ,
You can refer the following link to make conditional formatting for your visual, please find the details in the attachment.
Apply conditional formatting in tables and matrixes
Best Regards
2 Replies
Hi skaul ,
You can refer the following link to make conditional formatting for your visual, please find the details in the attachment.
Apply conditional formatting in tables and matrixes
Best Regards
To apply conditional formatting (icon) in Power BI on the "validatedFlag" column, follow these steps:
- Select the "validatedFlag" column in the Fields pane.
- Click on the "Conditional formatting" button under the "Visualizations" pane.
- Select "Icons" from the dropdown menu.
- Choose the "X" option under the "Set icons" section.
- Choose the "Red cross" icon under the "Icon style" section.
- In the "Icon criteria" section, select "is" and enter "X".
- Click on "Add another rule" to add another condition.
- Select "Icons" from the dropdown menu.
- Choose the "O" option under the "Set icons" section.
- Choose the "Green circle" icon under the "Icon style" section.
- In the "Icon criteria" section, select "is blank".
- Click "OK" to apply the formatting.
Once the above steps are followed, the "validatedFlag" column will have a red cross icon where the value is "X" and a green circle where the value is blank.
