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.
Memorable Memberanonymouseke I think that sample data would go a long way towards helping to figure out a solution to this.
I will prepare a sample!
Hello anonymouseke,
Thank you for posting your query in Microsoft Fabric Community Forum. Also, thanks to
GeraldGEmerick , for those inputs on this thread.Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Regards,
Harshitha.