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,
I have 2 tables.
1) Store sales
Columns: Id, StoreId, ProductId, SoldCount
Id is a unique key. A row means a sale of a product.
2) Store info
Columns: StoreId, Loc_State
StoreId is a unique key. A row means a store.
I want to create visualization for this question.
"% of stores that sold product x more than y" where x and y are user-defined values and x is ProductId and y is just a number.
Can Power BI plot data to answer this question?
Expected visualization would be simple 2 slice pie chart.
Thanks,
-Minsuk
I would imagine that you could put ProductId in a filter and SoldCount or a measure based upon SoldCount (like a measure that sums SoldCount) into a filter and then allow the user to change those filters as necessary.
The only interesting one would be getting a % of stores from that, I'll have to think about that.
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 |
---|---|
14 | |
2 | |
2 | |
1 | |
1 |