Forum Discussion
Filter table on dynamic, detached slicer values, then display filtered, aggregated data on a visual.
Hi anonymouseke,
you want both tables to show the same result even when Delivered on is not added, and it should work for both This week and Own period modes.this issue is happening because when Delivered on is not in the visual, Power BI groups the data by other columns, so the date filter doesn’t apply correctly.
The best way to fix this is to use a proper Date table and link it with your Delivered oncolumn. Then use that Date table in your slicers. This will keep your results the same whether Delivered
on is visible or not.
Hope this helps if you have any queries we are happy to assist you further.Regards,
Community Support Team.
Hi anonymouseke,
you want both tables to show the same result even when Delivered on is not added, and it should work for both This week and Own period modes.this issue is happening because when Delivered on is not in the visual, Power BI groups the data by other columns, so the date filter doesn’t apply correctly.
The best way to fix this is to use a proper Date table and link it with your Delivered oncolumn. Then use that Date table in your slicers. This will keep your results the same whether Delivered
on is visible or not.
Hope this helps if you have any queries we are happy to assist you further.
Regards,
Community Support Team.
Hi Anonymous ,
I eventually figured this out that I need a date table to filter the column independently. Now I use bookmarks to hide / reset 1 of the 2 slicers so I can have the 2 types working independently! Thanks for the support