Forum Discussion
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!
4 Replies
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-Forum/ba-p/963216
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/1447523Record # Inspection Date 030 Connectorization 040 Hardware Incorrect 041 Hardware Missing 063 Label Text Incorrect 070 Incorrect Components 081 Other Dimensional Length 090 Incorrect Amount of Solder 092 Bad Solder Joint 10 8/8/2023 0 0 0 0 0 0 1 3 11 8/8/2023 0 0 0 0 0 0 0 0 12 8/9/2023 5 0 0 0 0 0 0 0 13 8/9/2023 0 0 0 0 4 0 0 0 14 8/9/2023 0 2 2 0 0 0 0 0 15 8/9/2023 0 0 0 0 0 0 0 0 16 8/9/2023 0 0 0 0 0 0 0 0 19 8/2/2023 0 0 0 0 0 0 0 0 20 8/4/2023 0 0 2 0 0 0 0 0 21 8/4/2023 0 0 0 0 0 0 0 0 22 8/4/2023 0 0 0 0 0 0 0 0 23 8/4/2023 0 0 0 0 0 0 0 0 24 8/3/2023 0 0 0 0 0 0 0 0 25 8/4/2023 0 0 0 0 0 0 0 0 26 8/4/2023 0 0 0 400 0 0 0 0 29 8/4/2023 0 0 2 0 0 0 0 0 30 8/2/2023 0 0 0 0 0 0 0 0 See attached. Please study the Power Query transforms.
