Posts

Showing posts with the label Conditional format

Conditional format of fields in Power BI

Image
Open Power BI desktop and click on use sample data Click on Load Sample Data Click on check box beside financials data sheet. Click on load-to-load data to data model. Drag and drop table to canvas. Drag and drop required columns to table. Right click on any one of column in build tab and select conditional formatting as shown in bellow. Select conditional formatting as background color. Change format style as rules. Create rules as you required. Click on Ok. Font Color: Select conditional formatting as Font color. Change format style as rules. Create rules as you required. Click on OK. Data Bars: Select conditional formatting as Font color. Click on OK. Icons: Select conditional formatting as Icons. Select field as shown in bellow. Click on OK.