topic % from Original Bar Chart in Custom Visuals Development Discussion

% from Original Bar Chart

Anonymous — Thu, 21 Mar 2024 19:00:20 GMT

Is there a way to recreate this Excel chart in Power BI? I was unable to figure it out in Power BI so I resorted to Excel to at least achieve the visual that I wanted, but I need the automation that Power BI provides. My struggle was creating the "part of a whole" type of bar chart where one series represents the original specific capacity of an asset (grey) and another represents the residual specific capacity (blue). My client also desires a % value that represents the % remaining from original specific capacity (blue/grey). I was forced to manually draw a secondary axis on the right side as the workaround in Excel for the blue series because it is essentially on a secondary axis already. I apologize if the screenshot is blurry, really looking to get some insight on how to make this work in Power BI.

Re: % from Original Bar Chart

lbendlin — Fri, 22 Mar 2024 00:46:42 GMT

Sounds like a job for Deneb.

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data 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.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: % from Original Bar Chart

Anonymous — Fri, 22 Mar 2024 12:51:50 GMT

WELL ID	ORG SC	MOST RECENT SC	% SC RESIDUAL
W1-1	29.90	10.80	36.12%
W1-2	29.90	16.70	55.85%
W1-3	38.30	40.80	106.53%
W1-4	45.60	16.00	35.09%
W1-5	44.20	15.40	34.84%
W1-6	32.90	60.00	182.37%

First column = x axis labels

Second column = grey bar (original installation capacity)

Third column = blue bar (most recent measured capacity)

Fourth column = dotted line (column/2nd column) (Represents % of Original)

Let me know if this is in an appropriate format- this is the first time I've done this. Thank you very much.

Re: % from Original Bar Chart

lbendlin — Sun, 24 Mar 2024 00:33:27 GMT

Something like this?

Your fourth column makes no sense from a visual design perspective. You cannot use a line chart across wells, especially not if they are sorted alphabetically. Line charts should only be used for temporal relationships. Additionally, the percentage data is already there in the relationship between the bars so adding it again would violate another visual design rule.