From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Apply conditional formatting

Apply conditional formatting - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Apply conditional formatting

“

- [Instructor] Okay, so in this sub lesson, we are going to apply conditional formatting. Okay, in this sub lesson, we are going to configure conditional formatting. All right, so with conditional formatting for tables and Power BI Desktop, you can specify customized cell colors, including color gradients, based on cell values. You can also represent cell values with data bars or KPI icons, or as active web links. You can apply conditional formatting to any text or data field as long as you can base the formatting on a field that has numeric color name or hex code or a web URL value. So with conditional formatting, you can format the background or font color, format by color scale, rules, color values, or a calculation, add data bars or icons, format as web URLs, or format totals and subtotals. So let's go to the Power BI Desktop and take a look. Okay, so I am on an existing report that already has conditional formatting applied to it. So what I'm going to do here is just show you…

Contents