Power BI Conditional Formatting – Background, Font, Data Bars   Recently updated !


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

Leave a comment

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