Forum Discussion
Dynamic period in Timeline slicer
Hi catmint ,
Please create relationship between the 2 tables.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Community Support Team _ Rongtie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous !
Thank you for your quick response and trying to help.
I made an example .pbix and attach it.
In my example, table1 contains only three columns.
Budget version - contains several versions of the budget, but actuals are not complete. That's why I want to limit the date selection range when selecting this version. So that when comparing one version to another, the capture will be by the last available actuals date.
I tried to make an additional table to filter with a limited date range, but it does not allow me to compare 2 versions because it limits the context (VersionsDates)
As an example I made 2 sheets in the report, on the first "Works" dynamic version selection works, but without dynamic range selection. On the second sheet "Not Works" the range selection works when selecting Actuals, but no ability to select a version to compare.
Link: https://1drv.ms/u/s!ApO9IZha2FT_gSq7ToCXXVX7GuWo?e=9y9SC6