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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
allisonchung3
New Member

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors