cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sandeepiiit Frequent Visitor
Frequent Visitor

Does PowerBI support 100% stacked area chart?

I looked at all the available chart types in PowerBI desktop. I can find 100% stacked column chart, but don't see a similar area chart. Note that I can see the normal area chart, and the stacked area chart, but not 100% stacked area chart. Am I missing something obvious?

1 ACCEPTED SOLUTION

Accepted Solutions
P3Tom Regular Visitor
Regular Visitor

Re: Does PowerBI support 100% stacked area chart?

Have you considered using a 100% stacked column chart with one column?

 

Or have you considered creating measures for percentages that will effectively make the stacked area chart into a 100% stacked area chart?

 

Worth giving it a try.

 

Tom

http://www.powerpivotpro.com

View solution in original post

3 REPLIES 3
P3Tom Regular Visitor
Regular Visitor

Re: Does PowerBI support 100% stacked area chart?

Have you considered a 100% stacked column chart with one column?

 

Or have you considered creating measures that would give you the percentages needed to make the 100% stacked area chart into the equivalent of a 100% stacked area chart?

 

Tom

htttp://www.powerpivotpro.com

P3Tom Regular Visitor
Regular Visitor

Re: Does PowerBI support 100% stacked area chart?

Have you considered using a 100% stacked column chart with one column?

 

Or have you considered creating measures for percentages that will effectively make the stacked area chart into a 100% stacked area chart?

 

Worth giving it a try.

 

Tom

http://www.powerpivotpro.com

View solution in original post

Jasmin Occasional Visitor
Occasional Visitor

Re: Does PowerBI support 100% stacked area chart?

Hi Tom,

 

I'm new in Power BI and need a 100% stacked area chart for our turnover shares for the last years.

Do you have any tips for me, which measure i can use for a 100% stacked area chart?

 

I also tried your idea with the 100% stacked column chart, but it doesn't looks very well. 

 

Thanks for any help.

 

Best regards 

Jasmin

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 153 members 1,560 guests
Please welcome our newest community members: