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.
Now we are back to the original question. When not including the DeliveredOn date, which I don't want to include, the table values are not correct. All of the above things should work.
So a 'This week' selector and a 'date range' where the user can choose. With the table with or without DeliveredOn values being the same.
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