- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

# Column Series / Legend as a Percent of Column Itself?

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-26-2018 06:50 PM

Hi,

In the screenshot below, I'm trying to overlay "Persona" penetration in a particular product.

So for instance, on the axis I have the Product's penetration (e.g. % of grand total) but in the Legend / Column Series field, I have the Persona. Unfortunately. the percentages come up in the graph as follows:

- % = (Total Product 1, Persona A) / (Total Product)

'm looking for...

- % = (Total Product 1) / (Total Persona A)
- % = (Total Product 1) / (Total Persona B)
- % = (Total Product 1) / (Total Persona C)

Any ideas how I can achieve this?

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-26-2018 08:18 PM

Hi,

Something like this

=SUM(Data[Value])/CALCULATE(SUM(Data[Value]),ALL(Data[Product]))

Hope this helps.

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-26-2018 09:28 PM

HI there,

I created that measure, but not sure how this would help? If I use it column values, the calculatations are not right...

Measure 2 = sum(Table[Customer ID])/CALCULATE(Sum(Table[Customer ID]),ALL(Table[Product]))

thanks for your time

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-27-2018 07:33 AM

Update: maybe this is a better represnetation https://i.imgur.com/QjtEXBa.png

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-27-2018 07:06 PM

Hi,

Share the link from where i can download your PBI file.

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-29-2018 01:06 PM

https://www.dropbox.com/s/muv2a2rugmloujv/Dashboard%20Example.zip?dl=1

Here’s also a visual explanation of why I’m trying to accomplish: https://i.imgur.com/QjtEXBa.png

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-29-2018 05:19 PM

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-29-2018 08:57 PM

Wow, thanks -- this is what I was looking for. The only "issue" is that I lose the product penetration on the y-axis (% of customer grand total)

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-30-2018 04:16 PM

You are welcome. What do you mean by "I lose the product penetration on the y-axis (% of customer grand total)"??

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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content

07-30-2018 06:14 PM

On the y-axis, I wanted to display the % of total customers that were on that product. That is, SUM (Customers with product A) / SUM(All Customers).

Note that on your file you sent, the % on the y-axis are different than what I originally had. Unfortunately I'm not sure if it is possible given the structurre that I am seeking -- but I really appreciate your help