Conditional Formatting Icon. To format by rules select a based on field summarization method icon layout icon alignment icon style and one or more rules. This is done by selecting all of the diff cells and then picking the desired icon set from the following ribbon command.
You can t apply icons color scales or data bars with a custom formula. Select a blank cell beside the data list for instance f2 type 67 then in the below cells type 33 and 0. Click conditional formatting icon sets under home tab then select the icon set you prefer.
The sql server database needs to be connected to power bi desktop.
Power bi rag icons custom conditional formatting step 1. From the home tab you can select conditional formatting and choose manage rules. To hide the cells values select the show icon only check box. Format only cells that contain text number or date or time values to more easily find specific cells within a range of cells you can format those specific cells based on a comparison operator.
