cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
newbie1231 Occasional Visitor
Occasional Visitor

Stacked Column Chart with Targets / Actuals / Percentage

Hi All,

 

could someone please help me to figure out how to rebuild the below (Excel stacked column chart) in Power BI?

Capture1.PNG

 

 

The total (100%) would be the target value, for example 682 in the second column. Target was reached with 509 (actual) so 173 to go to reach the target. This means 75% of the target have been reached.

 

Hope this makes sense? I have the target and the actual values in two spreadsheets that have been added to PBI, relationship has been built already. 

 

However, the standard stacked column chart in PBI just adds up, it shows 509 actual and 682 target so the whole column shows as 509+682 = 1191. I need the 509 to show as part of the 682 target, incl. % reached. So basically exactly what I get in Excel and what's shown in the pic attached.

 

Hope it's not a stupid question, I'm really new to this..

 

Appreciate your help!!

 

 

2 REPLIES 2
jthomson New Contributor
New Contributor

Re: Stacked Column Chart with Targets / Actuals / Percentage

You could make a measure shortoftarget = target-actual and use that in your visual rather than the target?

Anonymous
Not applicable

Re: Stacked Column Chart with Targets / Actuals / Percentage

Im facing a similar issue, even if i try putting in a measure the value tends to go below 0 instead of going above 100 is there any way in which I can deal with this issue

 

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 553 members 4,830 guests
Please welcome our newest community members: