Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi, i have a problem with my pie chart. My fact table, Sales has values:
Product OrderDate SaleValue
Prod1 2020-04-05 45
prod2 2020-04-01 90
prod3 2019-02-14 20
prod2 2019-02-10 90
prod1 2018-10-10 10
prod4 2002-01-05 9
I need to create a pie with top 2 categories by salevalue and 3 category as others
pie categories;
prod 2 - 180
prod 1- 55
others (as prod3, prod4) - 29
thanks for help!
Solved! Go to Solution.
it seems as good solution byc it doesnt work with my measure, could You help me? For ranking I create measure like this;
SOS AM =
DIVIDE(
calculate(sum(SaleValue);MONTH(vfact_Points_Details[Date]) = MONTH(TODAY()))
;
CALCULATE(sum(SaleValue);MONTH(vfact_Points_Details[Date]) = MONTH(TODAY());ALL(vfact_Points_Details[Name]))
)
I need ratio percentage sum(SaleValue) to sum(SaleValue) all products
And then do pie chart with product and SOS AM (top)
If i do like in Your article I got 100% for every products without others 😞
User | Count |
---|---|
20 | |
18 | |
17 | |
11 | |
7 |
User | Count |
---|---|
29 | |
28 | |
13 | |
12 | |
12 |