Forum Discussion
gpminsuk
10 years agoRegular Visitor
How can Power BI create visualization for this scenario?
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...
Greg_Deckler
10 years agoCommunity Champion
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.