Power BI Conditional Formatting – Background, Font, Data Bars

Job-ready Online Courses: Click, Learn, Succeed, Start Now!

1. Objective

In our previous Power BI session, we learned How to work with a table in Power BI. Today, we will discuss how Power BI Conditional Formatting in tables can be done? We will start Power BI conditional formatting from the background colour shading, font colors shading, and data bars shading.
So, let’s start Power BI Conditional Formatting Tutorial.

Power BI Conditional Formatting - Background, Font, Data Bars

Power BI Conditional Formatting – Background, Font, Data Bars

2. Power BI Conditional Formatting

For Conditional Formatting in Power BI, you can determine modified cell hues in light of cell esteems, or in light of different qualities or fields, including utilizing inclination hues. You can likewise show cell esteems with information bars.
To get to contingent arranging, in the fields well of the visualizations sheet in Power BI Desktop, select the down-bolt next to the incentive in the Values well that you need to an organization (or right-tap the field). You can just oversee restrictive designing for fields in the Values territory of the Fields well.
Do you know How to Create Power BI Waterfall Chart

Power BI Conditional Formatting

Power BI Conditional Formatting – Menu Bar

The accompanying areas depict every one of these three contingent organizing alternatives. At least one alternatives can be joined in a solitary table section.
Note – At the point when connected to a table, restrictive designing abrogates any custom table styles connected to the restrictively organized cells.
To expel for Power BI Conditional Formatting from a perception, without flaw tap the field once more, select Remove restrictive organizing and after that the kind of designing to evacuate.

Power BI Conditional Formatting

How to Remove Conditional Formatting in Power BI

Read about How to Create Power BI Dashboard with Example 

3. Background Shading Scale

Choosing Conditional Formatting in Power BI and after that Background, shading scales raises the accompanying exchange.

Power BI Conditional Formatting

Step.1 Power BI Conditional Formatting – Background Shading Scale

You can choose a field from your information model to construct the hues with respect to, by setting Color in view of to that field. What’s more, you can determine the collection write for the chose field with the Summarization esteem. The field to be shaded is indicated in the Apply shading to handle, so you can follow along. You can apply contingent organizing to content and date fields, as long as you pick a numeric incentive as the premise of the arranging.

Power BI Conditional Formatting

Step.2 Power BI Conditional Formatting – Background Shading Scale

To utilize discrete shading esteems for given esteem ranges, select Color by rules. To utilize a shading range, leave Color by rules unchecked.

Power BI Conditional Formatting

Step.3 Power BI Conditional Formatting – Background Shading Scale

Have a Look at How to Use Power BI Bookmark 

4. How to Shade (Color) by Rules in Table?

When you select a color by rules for Power BI Conditional Formatting, you can enter at least one esteem goes, each with a set shading. Each esteem run begins with an If esteem condition, an and esteem condition, and a shading.’

Power BI Conditional Formatting

Step.1 To Color by Rules in Table

Table cells with values in each range are loaded with the given shading. There are three guidelines in the accompanying figure.

Power BI Conditional Formatting

Step.2 To Color by Rules in Table

The case table currently resembles this:

Power BI Conditional Formatting

Step.3 To Color by Rules in Table

5. How to Shade (Color) Least to Most Extreme in Table?

You can design the Minimum and Maximum qualities and their hues in Power BI Conditional Formatting. In the event that you select the Diverging box, you can arrange a discretionary Center an incentive too.

Power BI Conditional Formatting

Step. 1 Color Least to Most Extreme in Table

Follow this link to know about Power BI Card Visualizations – Two Ways for Creating Card
The illustration table currently resembles this:

Power BI Conditional Formatting

Step. 2 Color Least to Most Extreme in Table

6. How to Shade (Color) Text Style in Table?

Choose Power BI Conditional Formatting and after that Font, shading scales raises the accompanying discourse. This exchange is like the Background shading scales discourse, however, changes the textual style shading as opposed to the cell foundation shading.

Power BI Conditional Formatting

Step. 1 Color Font Style in Table

The illustration table currently resembles this:

Power BI Conditional Formatting

Step. 2 Color Font Style in Table

7. How to Shade (Color) Information Bars?

Choose Power BI Conditional Formatting and after that Data bars raises the accompanying discourse.

Power BI Conditional Formatting

Step.1 Conditional Formatting in Power BI – Shading Data Bar

Do you know How to Create Power BI Donut Chart 
Of course, the Show bar just alternative is unchecked, thus the table cell demonstrates both the bar and the genuine esteem.

Power BI Conditional Formatting

Step.2 Conditional Formatting in Power BI – Shading Data Bar

On the off chance that the Show bar just choice is checked, the table cell just demonstrates the bar.

Power BI Conditional Formatting

Step.3 Conditional Formatting in Power BI – Shading Data Bar

So, this was all about Power BI Conditional Formatting. Hope you like our explanation.

8. Conclusion

Hence, in this Conditional Formatting tutorial, we learned how can we use Power BI Conditional formatting in the background, font, and data bar. Furthermore, if we miss anything in this “Power BI Conditional Formatting Tutorial”, feel free to share with us.
Related Topic – Create Hyperlink in Power BI in Dashboard 
For reference

Did you know we work 24x7 to provide you best tutorials
Please encourage us - write a review on Google

courses

1 Response

  1. Paula Lopes says:

    The usage of English in this tutorial is terrible!! Is almost impossible to understand! I get the impression the text is the result of a bad automatic translation from other language. It’s a pity because some (many?!) of the tutorials are quite informative with a good explanation of the theme. But this one is useless…. 🙁

    Example:
    IN:
    “2. Power BI Conditional Formatting
    For Conditional Formatting in Power BI, you can determine modified cell hues in light of cell esteems, or in light of different qualities or fields, including utilizing inclination hues. ”

    I guess the sentence should be something like:
    “With Conditional Formatting in Power BI, you can modify cell color based on cell values, or based on fields…….., including the use of color scales. ”

    From Microsoft Power BI help:
    “With conditional formatting for tables in Power BI Desktop, you can specify customized cell colors, including color gradients, based on field 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 base the formatting on a field that has numeric, color name or hex code, or web URL values.”

Leave a Reply

Your email address will not be published. Required fields are marked *