Showing results for 
Search instead for 
Did you mean: 
gpminsuk Frequent Visitor
Frequent Visitor

How can Power BI create visualization for this scenario?



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.




Super User
Super User

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

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.

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Helpful resources

New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)