Logo

Customize Your Power BI Report’s Color Scheme with DAX Expressions

Colors are a fundamental piece of information representation in Power BI. They help to feature significant data and make the information more available and justifiable to the end-clients. In any case, in some cases, the default variety conspire in Power BI may not meet your requirements, and you might have to tweak the varieties to make an all the more outwardly engaging report. In this article, we will talk about using Power BI’s DAX expressions to control colors.

Introduction to DAX Expressions Power BI’s formula language, DAX (Data Analysis Expressions), is used to create custom calculations and measures. DAX expressions let you change data and make complicated formulas that can control your report’s colors. DAX articulations are like Succeed recipes and follow a similar language structure.

Utilizing DAX Articulations to Control Tones

There are a few DAX capabilities that can be utilized to control colors in Power BI. You can alter the color of a data point based on a particular condition or measure value using these functions. Let’s take a look at some of the most frequently used color control DAX functions.

1. Switch Function

The SWITCH capability permits you to test numerous circumstances and return an alternate outcome for each condition. It can be used to change a data point’s color based on a particular value or condition. An illustration:

Example
Color =

SWITCH(

TRUE(),

[Sales] > 100000, “Green”,

[Sales] > 50000, “Yellow”,

[Sales] <= 50000, “Red”

In this example, we are utilizing the Change capability to set the shade of an information point in light of the worth of the [Sales] measure. The color will be changed to “Green” if the [Sales] value is greater than 100,000. On the off chance that the [Sales] esteem is somewhere in the range of 50,000 and 100,000, the variety will be set to “Yellow.” Assuming the [Sales] esteem is not exactly or equivalent to 50,000, the variety will be set to “Red.”

2. Colour Function

The Color function allows you to set the color of a data point based on a specific RGB value.

Here’s an example:

scssCopy codeColor = Color.FromRGB(255,0,0)

In this example, we are using the Color function to set the color of a data point to red. The RGB values are specified as arguments in the function. The first argument represents the red value, the second argument represents the green value, and the third argument represents the blue value.

3. Color Scale Function

The Color Scale function allows you to set the color of a data point based on a specific color scale. Here’s an example:
cssCopy codeColor = ColorScale.RedYellowGreen([Sales])

In this example, we are using the Color Scale function to set the color of a data point based on the [Sales] measure. The function uses a red-yellow-green color scale, where red represents low values, yellow represents moderate values, and green represents high values

Conclusion

In conclusion, we talked about using Power BI’s DAX expressions to control colors. DAX articulations give a strong method for modifying the variety plan of your report and make it all the more outwardly interesting to the end-clients. We looked at SWITCH, Color, and Color Scale, three of the most frequently used color control DAX functions, among others. By utilizing these capabilities, you can make a custom variety plot that meets your requirements and improves the general client experience.

Contact Us

Contact Styrex Solutions for further enquiries.