The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Using the following data;
State | Amount 1 | Amount 2 | Percentage Amount 2 |
NSW | $500,000 | $89,000 | 17.80% |
VIC | $450,000 | $56,986 | 12.66% |
QLD | $350,000 | $36,589 | 10.45% |
Is it possible to chart a Clustered Column Chart that uses the variable "Percentage Amount 2" as the bars but the line should be the percentage of the total of Amount 2 divided by the total of Amount 1.
Example: Amount 2 [$182,575] / Amount 1 [$1,300,000] = 14.04%
The chart should like this;