topic Re: Bar Chart Column Size & Order in Custom Visuals Development Discussion

Bar Chart Column Size & Order

Anonymous — Tue, 07 Nov 2023 21:20:10 GMT

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!

Re: Bar Chart Column Size & Order

lbendlin — Mon, 13 Nov 2023 01:54:20 GMT

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/1447523

Re: Bar Chart Column Size & Order

Anonymous — Mon, 13 Nov 2023 16:17:55 GMT

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

Re: Bar Chart Column Size & Order

Anonymous — Mon, 13 Nov 2023 16:18:30 GMT

I'm looking to create a graph similar to this

Re: Bar Chart Column Size & Order

lbendlin — Mon, 13 Nov 2023 16:32:53 GMT

See attached. Please study the Power Query transforms.