Future-Proof Your Career, Master Data Skills + AI

Blog

Blog

# Fill Bar Chart – A Bar Chart Variety For Power BI Reports

by | 7:00 pm EDT | September 05, 2021 | DAX, Power BI

In this tutorial, you’ll learn how to create a new type of bar chart visualization called Fill Bar Chart. It’s a chart that shows the current and total value of a category, then gives an image of a bar chart being filled. You’ll also learn how to turn it into a new variety of donut chart using polar coordinates.

## Exporting A Dataset To Charticulator

First, create and export a dataset to Charticulator. The dataset used in this example contains Year, Total Defects, and Total Defects All.

Click the ellipsis on the table and select Export Data.

Next, go to charticulator.com and click Launch Charticulator.

Then, locate and open the exported dataset. After that, you’ll be redirected in the Charticulator canvas.

## Designing The Fill Bar Chart

Create the main shape of the chart by placing a rectangle in the Glyph canvas.

Change the stacking of the bars to Stack Y.

Now, you need to put the measures in the x-axis. Click Data Axis and place it on the x-axis of the rectangle inside Glyph.

Place it from the bottom left to the bottom right of the axis. Data Axis allows an axis to have multiple measures in it.

Once done, put Total Defects and Total Defects All in the Data Axis inside the Glyph canvas.

Your chart will then look like this.

In the DataAxis1’s Attributes, set the Range to 0 so that the values on the x-axis will start at 0.

Next, delete the rectangle in the Glyph canvas and define the shapes of the measures. Place a rectangle in the Glyph from the left side to the point of the first measure.

For the second measure, place a rectangle from the point of the first measure to the end of the axis.

## Adding Colors To Fill Bars

Add colors to each bar in the chart. Open Shape1’s Attributes and place Total Defects in the Width section.

If you add a color in the Fill section of Shape1’s Attributes, you’ll see that the bar for the current value is emphasized.

The yellow bar is the current value while the gray bar is the total value. It is now giving the image of the current value filling the total value.

Hide the Data Axis by opening DataAxis1’s Attributes and unchecking the Visible box.

Next, reduce and adjust the size of the bars in the Shapes’ Attributes. Add circles in the Glyph canvas to make it look like a round bar chart. Drag two circles from Marks to Glyph and align them at both ends of the bar.

Adjust the size of the circles to match the size of the bars. Your Fill Bar chart will now look like this.

Lastly, create a gap between the bars by dragging one bar away from the other.

## Exporting The Fill Bar Chart To Power BI

Save the file and export it to Power BI Custom Visual.

Uncheck the auto axis options in the Axes and Scales settings to avoid changes in the axes when a filter context transition is invoked. Then, input a visual name and export the chart file.

Open Power BI and import the Fill Bar chart file. Click the ellipsis below Visualizations and select Import a visual from a file.

Locate and open the file. Then, click the Charticulator icon with the visual name of the file. You will then see the visual in the dashboard.

Adjust the margins and the background to match your data report and preference. Once done, the Fill Bar chart will now look like this.

If you only want to show one bar in your report, go to the Filter section and set the filter type to Basic Filtering. You’ll see a filter selection for the years 2018 and 2019. Then, check the box of the year that you want to display in your report.

You can also use another chart to invoke context transitions. For this example, a simple bar chart is used. Go to the Format tab and click Edit Interactions. Next, create an interaction between the Fill Bar chart and bar chart.

If you select a bar in the bar chart or any chart that you used, you will see that the Fill Bar Chart will change.

## Transforming The Chart Using Polar Coordinates

Another thing you can do is turn the bar chart into a donut chart. Remove the circles from both ends of the bar and then drag Polar to the canvas. You’ll see that the Fill Bar chart is now a Fill Donut Chart.

## Conclusion

If you want a new look for your bar charts, try practicing and utilizing this tutorial. Fill Bar charts will help make your Power BI reports look more interesting. They also make all the data and information inside the chart easier to understand.

Mudassir

## How to Calculate Age in Excel: 5 Best Methods Explained

Looking to calculate age in Excel? Well, you're in the right place. Whether you need to find the age of...

## How to Interpolate in Excel: User Guide With Examples

In data analysis, interpolation plays a crucial role in estimating values that fall between known data...

## Funny ChatGPT Prompts: 20 Hilarious ChatGPT Ideas

In a world where technology continues to amaze us, we have now arrived at the point where we can have a...

## How Many Rows Can Tableau Handle?

Are you dealing with a large data set? Are you wondering how many rows can Tableau handle efficiently?...

## How to Update Tableau in 4 Quick Steps

With frequent updates and new releases, Tableau continues to evolve and improve its functionality. To...

## Power BI Slicer Search: User Guide With Examples

Ready to get started with the Power BI slicer? This feature will allow you to filter and slice your...

## What is Context Filter in Tableau? How to Apply and Set

One of the powerful features of Tableau is its ability to allow users to interact with data...

## How to Number Columns in Excel Automatically: 5 Quick Ways

In Excel, numbering columns is an important and straightforward process that can help you organize and...

## How to Make a Logo Transparent in PowerPoint: Quick Guide

A transparent logo can be a powerful tool in your branding arsenal. It allows your logo to seamlessly...

## Excel Waterfall Chart: Guide to Create, Design & Impress

Have you heard of an Excel waterfall chart but are unsure how to create one and make it stand out?...

## Tableau Tooltip: A Design Guide for Customization

Are you ready to use Tableau tooltips to level up your visualizations and make them more insightful and...

## What is a Set in Tableau and How to Create Them: User Guide

Are you getting started with Tableau and looking to create a set? Well, you're in the right place. In...