Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
17 | |
11 | |
5 | |
4 | |
3 |