Has anyone figured out how to have a date filter sync across datasets due to the relationship model limitation? I bring in different data sets to circumvent this row redundancy issue but then visuals are filtered by different date filters on same page.
Hey @reavelyn_pray ,
welcome to the community
If you want to avoid joining the data based on the date fields you can use Parameters.
In case you want to select a range you need two parameters. In the parameter you can select the date, and by combining a parameter with a calculated field you can filter the result of the calculated field on all sheets.
Best regards,
Nico
Hello @reavelyn_pray,
I recommend creating two separate date parameters: Start Date and End Date.
You can set these dates according to your needs, which will allow you to filter all the datasets dynamically. If you want to filter the data separately, you can use a calculated field to achieve the desired output using the Start Date and End Date parameters.
I believe this approach will enable you to handle multiple date fields across your different datasets effectively.
Best,
Vaibhav Narwade.
Hi @reavelyn_pray,
It’s been awhile since we last heard from you, did you have any additional questions or were you able to find a work around from one of the solutions provided above?
If we do not hear back within the next 3 business days, I’ll close out this topic.
Thank you!
Sorry this is great! Thank you