Forum Discussion
Using a slicer based on a joined table...
Hi, I've got two tables: one is 'sales' data with a single date column; one is 'date' data containing ISO weeks, periods and years, etc. I've linked the two tables so that I can filter my sal...
Hi Matty,
You can create a calculated column in 'date' table using the formula.
column=RELATED(sales[sale])
Create a New Table based on the column above.
New Table=FILTER('date','date'[column]<>BLANK())
Finally, create a slicer using the field in New Table.
Best Regards,
Angelia