Forum Discussion
Filter Table
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 - 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.
Click the dropdown next to Name in the values well and then click "Show items with no data"
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 - 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.
