Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

Helper I
Helper I

Formatting Categories


I'm having a weird issue with formatting a category label. With one value onthe Y-Axis the categories format stacked text which is what i want. but with a different value showing the same type of data which it's formatting diagnol and won't format stacked unless i make the chart really wide. But then in a different BI file i have the same chats formatting correctly and its a smaller page layout:


1 - Using SUM Potential GP shown as % it formats like this, but i want it to format the same as the left chart.


2. Using the the different categories but using the same Y-AXIS value as the left chart it formats correctly, but the its showing the wrong accounts:


3 - an old version of this dashboard using the same fields i want to use in both charts formats correctly. but the page layout is smaller just standard 16:9 where as the new dashboard i'm building each page is 1920 x 1080, the only difference on this is that the the 7 axis is a measure calculation that is doing the same as display a % of grand total option:



Any ideas whats going on?



Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors