Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
'm looking for...
Any ideas how I can achieve this?
Hi,
Share the link from where i can download your PBI file.
Hi,
It works fine. Here is the result i got. You may download my file from here.
Thanks! Have spent hours solving this, and this finally worked!
You are welcome.
Quick question. Is there a way to omit blanks? I have in one country where 50% of responses are "blanks" and I don't want them to be counted at all.
Hi,
Share some data to work with and show the expected result.
Hi again,
I managed to fix it by using the ALLSELECTED and use filters to remove blanks.
But thank you.
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)
You are welcome. What do you mean by "I lose the product penetration on the y-axis (% of customer grand total)"??
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
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.
Best Regards
Maggie
Hi,
That is not possible. If my previous reply helped, please mark it as Answer.
Hi,
Something like this
=SUM(Data[Value])/CALCULATE(SUM(Data[Value]),ALL(Data[Product]))
Hope this helps.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |