How can Power BI create visualization for this scenario?

gpminsuk — Sun, 10 Apr 2016 03:56:31 GMT

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

Re: How can Power BI create visualization for this scenario?

Greg_Deckler — Sun, 10 Apr 2016 14:46:13 GMT

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.

topic Re: How can Power BI create visualization for this scenario? in Developer

How can Power BI create visualization for this scenario?

Re: How can Power BI create visualization for this scenario?