Data Labels in Pivot Chart created from Power Pivot Data Model Excel 2013

[kjsab]

I am fairly new to Power Pivot. I have created a stacked column pivot chart, based on 3 data points / fields. (All 3 fields exist within the same source table in my data model):
Series = Item Type (4 items total)
Category = Quarter
Value = Count of Items

I am showing 3 qtr's worth of data, so for each qtr, I see 4 columns...one representing each item type.

If I show data labels, it defaults to the value (1,6,5,24 for example). Rather than show the actual value, I would like to show the % of the SERIES...meaning 1 = 2.8%; 6 = 16.7%, etc.)

I guess I'm basically looking for a 'Value Field Settings' option, without having a source 'pivot table' necessarily, since my chart fields come directly from the data model.

Is this possible?

 

[scottsen]

It wouldn't suprise me if there was a way to do this -- not unlike "Show Value as > Percent of Total" in a pivot table. But I don't see how to do this in a chart directly (though, if you create a chart FROM a table, then the Show Value as sorta flows through...).

In general, I tend to write new measures for things like this.

Some Total := SUM(SomeTable[SomeColumn])
% of Total := DIVIDE([Some Total], CALCULATE([SomeTotal], ALL(SomeTable)))

There will be variation here depending on what you are trying to do, but hopefully you get the point...

 

[kjsab]

Thanks, scottsen.

Yes, the "Show Value as" from Value Field Settings in a pivot is exactly what I was picturing in my head. I see where you're going w/ the new measure and that's probably the simplest & quickest resolution to my issue rather than trying to investigate what may or may not be possible!

Thank you for the response and example!!