Forum Discussion
% from Original Bar Chart
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.
3 Replies
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/1447523WELL 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.
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.
