Reply
Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

Column Series / Legend as a Percent of Column Itself?

 

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: 

 

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

 

'm looking for...

 

  1. % = (Total Product 1) / (Total Persona A)
  2. % = (Total Product 1) / (Total Persona B)
  3. % = (Total Product 1) / (Total Persona C)

Any ideas how I can achieve this? 

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

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

Hi,

 

Something like this

 

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

 

Hope this helps.

Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

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

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 

Highlighted
Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

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

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

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

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

Hi,

 

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

Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

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

Hi, here’s a link

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
Super User
Posts: 3,947
Registered: ‎01-14-2017

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

Hi,

 

It works fine.  Here is the result i got.  You may download my file from here.

 

Untitled.png

Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

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

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)

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

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

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

Frequent Visitor
Posts: 8
Registered: ‎07-26-2018

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

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