topic To apply calculated field in Developer

To apply calculated field

skaul — Tue, 21 Mar 2023 12:54:15 GMT

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?

Re: To apply calculated field

Anonymous — Thu, 23 Mar 2023 02:31:54 GMT

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

Re: To apply calculated field

Adamboer — Thu, 23 Mar 2023 11:25:37 GMT

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.