Reply
Super User
Posts: 3,944
Registered: ‎01-14-2017

Re: Column Series / Legend as a Percent of Column Itself?

Hi,

 

That is not possible.  If my previous reply helped, please mark it as Answer.

Highlighted
Community Support Team
Posts: 2,542
Registered: ‎03-15-2018

Re: Column Series / Legend as a Percent of Column Itself?

Hi @ttam110

It is not possible to add the data as your picture. Here is a workaround

Change to Line and stacked column chart.

Create measures

sum per product = CALCULATE(COUNT(Dup[Product]),ALLEXCEPT(Dup,Dup[Product]))

all product = CALCULATE(COUNT(Dup[Product]),ALL(Dup))

% of customer grand total = [sum per product]/[all product]

add [ % of customer grand total] to line values.

5.png

 

 

Best Regards

Maggie

Attachment