Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Clustered Column Char adding a line that represents the total percentage and not the Average

Using the following data;

 

StateAmount 1Amount 2Percentage Amount 2
NSW$500,000$89,00017.80%
VIC$450,000$56,98612.66%
QLD$350,000$36,58910.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;

 

chart-example.png

0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.