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.
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.
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.
- Then select the excel from your local system
- The Navigator window will open, select the table and click on the Load button.
- 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.
- 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
Now, you can see the shaded area of the Power BI Area chart is transparent to 90.
This is how we can apply transparency property to the shaded area of the area chart in Power BI.
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%.
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.
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%.
Now, you can see the transparency property is applied to the background of the Area chart in 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:
- Pyramid Chart In Power BI
- Conditional Formatting in Power BI Area Chart
- Power Bi Stacked Column Chart Multiple Legends
- Power BI Bar Chart Rounded Corners
After working for more than 18 years in Microsoft technologies like SharePoint, Microsoft 365, and Power Platform (Power Apps, Power Automate, and Power BI), I thought will share my SharePoint expertise knowledge with the world. Our audiences are from the United States, Canada, the United Kingdom, Australia, New Zealand, etc. For my expertise knowledge and SharePoint tutorials, Microsoft has been awarded a Microsoft SharePoint MVP (12 times). I have also worked in companies like HP, TCS, KPIT, etc.
