Forum Discussion
Kalaivani
Helper III
Helper IIIHow to reset Between Date Range slicer based on another slicer selection
I have a Calendar Table and a FYTD_Rolling12Month_Custom table that has a Selection column with values - FYTD, Custom and Rolling 12 months. I made relationship between both based on Date Field ...
Hi Kalaivani ,
problem is, that you cannot sync a bookmark navigator across pages. Therefore you need a slightly different (and slightly more complicated) approach.
- Use three simple buttons instead of a bookmark navigator. Choose action type = Bookmark and select the appropriate bookmarks.
- Create a separate format measure for each of the three selections like this:
FormatMeasureFYTD = IF ( SELECTEDVALUE ( 'FYTD_Rolling12Month_Custom'[Selection] ) = "FYTD", "#000000", -- choose any color codes "#ffffff" )- edit the fill property of the buttons to dynamically and select the format measure
The conditional formatting based on [Selection] makes the buttons on different pages appear synchronised.
AMeyersen
Resolver III
Resolver IIIHi Kalaivani ,
problem is, that you cannot sync a bookmark navigator across pages. Therefore you need a slightly different (and slightly more complicated) approach.
- Use three simple buttons instead of a bookmark navigator. Choose action type = Bookmark and select the appropriate bookmarks.
- Create a separate format measure for each of the three selections like this:
FormatMeasureFYTD =
IF (
SELECTEDVALUE ( 'FYTD_Rolling12Month_Custom'[Selection] ) = "FYTD",
"#000000", -- choose any color codes
"#ffffff"
)
- edit the fill property of the buttons to dynamically and select the format measure
The conditional formatting based on [Selection] makes the buttons on different pages appear synchronised.
