Conditional format of fields in Power BI

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.

Comments

Popular posts from this blog

Exception deserializing the package "The process cannot access the file because it is being used by another process."

SSRS INTERVIEW QUESTIONS

Failed to execute the package or element. Build errors were encountered