- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I'm looking to create a graph similar to this
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Record # | 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 |
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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
Subject | Author | Posted | |
---|---|---|---|
01-24-2024 05:57 AM | |||
09-14-2024 07:09 AM | |||
06-04-2024 09:55 AM | |||
03-02-2024 06:36 AM | |||
12-25-2023 03:08 AM |
User | Count |
---|---|
5 | |
4 | |
3 | |
2 | |
1 |