Table/Matrix in Power BI with the variables as lines

[beaoliv123-_]

Hi there, 

I need help with the following situation:

I'd like to have a table in Power BI with the total sales by day, as shown in the table below. However, in each day, I would like to know which were the customers who bought. When I'm building the table on Power BI I use "Number of Sales" as values and "Date" and "CustomerID" as lines, so whenever I open each day, I would have a list of my clients who bought on that specific day.  However, instead of having only those ones who bought, I have a list of all my clients, and for those who disn't bought anything, there's a 0.

Taking into account that the list of clients is huge, I would like to ask you if you know a solution to exclude those CustomerID who did not bought in each day.

The table below is what I have right now:

Date	Number of Sales
01/01/2022	3
1234567	2
1674342	1
3213345	0

And this is what I wanted to have:

Date	Number of Sales
01/01/2022	3
1234567	2
1674342	1

[amitchandak]

@beaoliv123-_ , seem like you measure is having +0 . If so remove that.

Of use visual level filter Number of Sales > 0

[beaoliv123-_]

Hi,

thanks for your help.

The problema is that I have more columns, for example:

Date	Number of Sold Pens	Number of Sold Pencils
01/01/2022	4	3
54353	0	2
54987	2	1
43243	2	0

If I filter by > 0, then I'll exclude some rows. For example, for the number of sold pens I would exclude from the table the first client, but then it will be removed from the number of sold pencils even though he bought 2.