How to Apply Transparency in Power BI Area Chart?

Do you want to apply transparency to the Power BI area chart? In this Power BI tutorial, we will see how to apply transparency in Power BI area chart.

I have explained a small difference between colors and transparency.

To be transparent means to be see-through and invisible, while being colored means to be visible. Transparency depends on how much light passes through an object, while color is determined by how much light it reflects.

Here, we will see how to apply transparency to the shaded area and background of the Power BI area chart.

How to Apply Transparency in Power BI Area Chart [Shaded area]

Here, we will see how to apply transparency in the shaded area of the Power BI area chart.

The shaded area in a Power BI area chart shows the space beneath the line that connects the data points. It highlights the range or volume of data, which assists in recognizing trends and variations.

For example, we will use the Financial Excel workbook to create an area chart that will reflect COGS based on product.

power bi stacked area chart transparency

Once the Power BI area chart is created, we will apply transparency to the shaded area, which reflects Cogs based on Product.

We have the left chart, after applying transparency we landed on the right one.

power bi area chart transparency

Follow the below steps to apply transparency to the shaded area of the Power BI area chart.

  • Open Power BI Desktop, then click on Excel Workbook to load the data.
Area Chart change fill shading color or transparency
  • Then select the excel from your local system
  • The Navigator window will open, select the table and click on the Load button.
Power BI Area Chart change fill shading color or transparency
  • Select the Area chart from the visualization pane to create an area chart.
  • Then, drag and drop the COGS and Product to the Y and X-axis.
Microsoft Power BI Area Chart change fill shading color or transparency
  • To apply transparency to the Shaded area of the area chart, first click on the Format pane icon.
  • Then, scroll down to the Lines section and expand it.
  • Next, expand the Shaded area section and adjust the Transparency slider.
  • Increasing the number on the slider increases the transparency of the shaded area. I have provided transparency to 90
Power bi area chart transparency example

Now, you can see the shaded area of the Power BI Area chart is transparent to 90.

Microsoft Power bi area chart transparency example

This is how we can apply transparency property to the shaded area of the area chart in Power BI.

See also  How to Set Default Value in Power Apps Dropdown

Power BI area chart transparency [Background]

Here we will see how to apply transparent properties to the background of area chart.

For example, we will use the same Financial excel sheet to create a Area chart in Power BI, that will COGS based on Product.

Then, we will apply the background color and transparent the background color to 67%.

Microsoft Power bi area chart transparency

Follow the below steps to apply transparent to the background color of Power BI area chart.

  • In Power BI Desktop, select an Area chart from the visualization pane to create an Area chart.
  • Drag and drop the COGS and Product to the Y and X-axis, respectively.
power bi area chart background transparency

To transparent the background of the Power BI area chart, follow the below settings:

  • Now click on the Format pane icon; next, click on the General setting.
  • Expand the Effects section next and provide the Background color by clicking the dropdown.
  • Then, you adjust the Transparency slider. Increasing the number on the slider increases the transparency of the background color. I have provided transparency to 67%.
Microsoft power bi area chart background transparency

Now, you can see the transparency property is applied to the background of the Area chart in Power BI.

area chart transparency in Microsoft power bi

This is how we can apply transparency to the background of the Power BI Area chart.

Conclusion

In this Power BI tutorial, we saw how to work with transparency properties in the Power BI Area chart.

Here, we have covered the topics below:

  • Power BI area chart transparency for Shaded area
  • Power BI area chart transparency for Background

Some more Power BI articles you may also like:

>