Filter Table

[tarocha]

Hi, I'm starting on Power BI, could you help me with the following question.

I have a sales table, each sale that the seller makes is consolidated in that table.

I would like to create a table with the region and product filters, but when I filter continue showing all salespeople, and those who did not sell in that filter that is blank but remains in the table.

When I make the filters it filters the salespeople and lets only those who made the sales appear.

The image below shows the result I have and the expected.

Thanks in advance for your help.

TABLE SALES
NAME	REGION	PRODUCT	NUMBER SALES
ANDY	R1	P1	2
JONNY	R2	P2	3
RICK	R2	P1	2
ANDY	R3	P1	1
ANDY	R1	P2	4
RICK	R1	P2	2
MICK	R2	P3	1
MICK	R2	P3	5
MICK	R2	P2	2
JONNY	R2	P2	1
PATRICK	R4	P2	2

[amitchandak · Accepted solution]

@tarocha , for that you need to create star schema with name, region, and product table. Name is a must in this case.

Please find the file attached after signature

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

[lbendlin]

Click the dropdown next to Name in the values well and then click "Show items with no data"

[tarocha]

Hi @lbendlin 

This tip didn't work for me.
I attached the pbix to facilitate help.
Tks

[Greg_Deckler · Accepted solution]

@tarocha - I created a table like this:

Names = DISTINCT('Table'[NAME])

I related this table to the other table and I replaced NAME column in this table for the NAME column in the original table for Rows. Once I did this, I could click on the dropdown arrow for NAME in Rows and select "Show items with no data".

See attached PBIX file below sig.

[amitchandak · Accepted solution]

@tarocha , for that you need to create star schema with name, region, and product table. Name is a must in this case.

Please find the file attached after signature

https://www.sqlbi.com/articles/the-importance-of-star-schemas-in-power-bi/

[tarocha]

@lbendlin 

This tip didn't work for me.
I attached the pbix to facilitate help.
Link Pbix