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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
Eximius2286
Regular Visitor

Bar Chart Column Size & Order

Hello,

 

PowerBI newbie looking for some help.

 

I'm trying to create a bar chart arranged by size (pareto) with data filter by month but I'm running into some difficulties and hoping the community might be able to point me in the right direction.

 

First, how do I arrange a bar chart to sort within the visual from largest to smallest?

 

The second issue I'm running into is the bars on the chart are so small. I've adjusted the column spacing and minumum catagory width but it really didn't change much.

 

I'll include screen shots of my dashboard below for reference. 

 

And thanks in advance for any guidance provided!

 

Eximius2286_0-1699391927333.png

 

4 REPLIES 4
Eximius2286
Regular Visitor

I'm looking to create a graph similar to this

 

Eximius2286_0-1699892259914.png

 

 

See attached. Please study the Power Query transforms.

Eximius2286
Regular Visitor

Record #Inspection Date030 Connectorization040 Hardware Incorrect041 Hardware Missing063 Label Text Incorrect070 Incorrect Components081 Other Dimensional Length090 Incorrect Amount of Solder092 Bad Solder Joint
108/8/202300000013
118/8/202300000000
128/9/202350000000
138/9/202300004000
148/9/202302200000
158/9/202300000000
168/9/202300000000
198/2/202300000000
208/4/202300200000
218/4/202300000000
228/4/202300000000
238/4/202300000000
248/3/202300000000
258/4/202300000000
268/4/20230004000000
298/4/202300200000
308/2/202300000000
lbendlin
Super User
Super User

One of the first things you will want to learn when using Power BI is how to unpivot your data.  Then you will have a single measure value rather than what you have now. Then the sorting will be easier too.  etc.

 

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
If you are unsure how to do that please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

If you want to get answers faster please refer to https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors