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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors