Forum Discussion
% from Original Bar Chart
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
| 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.
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.