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 automat...
| 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.