Forum Discussion
Sjonne99
8 years agoFrequent Visitor
Group Customers by Percentage
Hi
Im trying to create a filter that divides my customers in different groups based on quantity and percentage of total customers, so that my customers are grouped by:
top 20%
20-40%
40-60%
60% -80%
80% - 100%
So that when i choses 80 -100 % i see how much sale amount the button 20 % consists of
As i am fairly new to PowerBI i dont know how to go about it, and i hope some of you experts can be of assistance.
Kind regards
Soren
2 Replies
- Greg_Deckler
Community Champion
Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
- v-yulgu-msft
Microsoft Employee
Hi Sjonne99,
We need more detailed information to test for you, such as sample dataset and expected output.
Regards,
Yuliana Gu