Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Anonymous
Not applicable

Budget, and Actuals Stacked Column Chart for Departments (x-axis labeling)

Hi Everyone, 

I need help regarding the x-axis labeling. I've been working on this model for weeks. I have gotten closer to my desired result but I'm pretty stumped. Hoping I can receive a solution to this problem. I would like to keep the stacked column look.

 

1. This is the model from another data visualization software that I would like to mimic in power BI.

 

allisonchung3_4-1652730213107.png

 

 

 

2. Below I attempted two times. As you can see (Exhibit A.) the labeling on the x-axis is pretty cluttered due to me having to differentiate between Actual and Current amounts and I would like it to be clean. 

 

Exhibit A. 

allisonchung3_3-1652730041070.pngallisonchung3_7-1652730798507.png

 

 

The second screenshot (Exhibit B.) is the desired aesthetic I would like however I am not sure how to move the actuals now that I have the Dept in the x-axis. Is it possible?

 

Exhibit B. 

allisonchung3_6-1652730560950.png

 

 

I would like the columns to look like Exhibit A, but the x-axis labeling to mimic Exhibit B. 

0 REPLIES 0

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors
Top Kudoed Authors