Format Funnel Chart in Power BI

How to Format Funnel Chart in Power BI with an example? Formatting Funnel Chart in Power BI includes changing the Funnel Chart Title, Box Colors, Title position, data labels, background Colors, etc.

To demonstrate these Power BI formatting options, we are going to use the Funnel Chart that we created earlier. Please refer to the Funnel Chart article to understand the steps involved in creating Power BI Funnel Chart.

How to Format Funnel Chart in Power BI

Please click on the Format button to see the list of formatting options that are available for this Funnel Chart.

Format Funnel Chart in Power BI 1

Format Category labels of a Funnel Chart

Category labels display the information about each box (Here, Sales Territory Region Names). You can use this section to format those labels. From the screenshot below, you can see that we changed the color of the label to Brick red, Text Size to 14, and Font family to Corbel.

Format Funnel Chart in Power BI 2

Format Power BI Funnel Chart Data Colors

By default, all the Funnel Chart Boxes display in single default color. You can use this Data Colors section to change the Box Colors.

Set category Labels On 3

First, toggle Show all options from Off to On. It allows you to pick the specific color for each box.

Change the Default Colors 4

For the demonstration purpose, we changed the Colors of all the existing boxes.

Add each colour to country 5

And you can see the result

Format Funnel Chart in Power BI 6

Format Data Labels of a Funnel Chart in Power BI

Data Labels display the Metric information (Sales Amount of each bar) about the bar.

As you can see from the screenshot below, we changed the Data labels Color to Dark Gray, Display Units from Auto to Thousands. We also changed the Label Position to Inside Center, Text Size to 20, and Font family to DIN.

Change Data Labels Color, display units, position, and text size 7

Format Conversion Rate Labels

Please select the Conversion rate Label, and toggle the option from Off to On. It displays 100% on the Top and 0% at the bottom of the Funnel Chart.

As you can see from the below screenshot, we change the Color to Green, the Font style to DIN, and Font Size to 15. In general, you can just disable this feature.

Change Conversion Rate Labels 8

Format Power BI Funnel Chart Title

By toggling the Title option from On to Off, you can disable the title of a Funnel Chart.

As you can see from the screenshot below, we change the Title Text to Sale Amount by Sales Territory Region. And we also changed the Font Color to Green, Font style to Corbel, Font Size to 27, and Title Alignment to center. If you want, you can also add the background color to the title.

Format title text, font colour, alignment, text size, and font family 9

Add Background Color to Funnel Chart

You can add the Background color to Funnel Chart by toggling the Background option to On. For the demonstration purpose, we are enabling this feature and adding a background color. Here, you can change the Transparency percentage as well.

Add background Color 10

Let me remove the background color by clicking the Revert to default option.

Add Border to Funnel Chart

You can add Borders to Funnel Chart by toggling the Border option from Off to On. For the demonstration purpose, we enabled Borders and added Black color as the Border color.

Add Borders 11

Use the General Section to Change the X, Y position, Width, and height of a Funnel Chart.

Format Funnel Chart in Power BI 12

Diverging option in Funnel Chart

If you add any valid column to the Color Saturation field, then you can use this Diverging option to add colors to the Funnel Chart Boxes. To demonstrate the same, we are adding the Sales Amount to Color Saturation.

Add Sales Measure to Color Saturation 13

Now, you can see that the Default Color option under the Data Colors section was replaced with the Diverging option. Let me add Minimum, Center, and Maximum color. Remember, you also have an option to add the Minimum, Center, and Maximum values.

Format Funnel Chart in Power BI 14