Hi All,
I am trying to write a measure that checks the selected value of a slicer along with the current active bookmark so a button can show some custom text. I can identify the slicer value but am unsure of how to identify which bookmark is currently active.
What I am trying to do is change the text on a button along the lines of.
IF(
SelectedValue(Metric[Direction]) = "Up"
,If(
Bookmark = "Up"
,""
,"Click the button to change the graph"
)
,If(
Bookmark = "Up"
,"Click the button to change the graph"
,""
)
)
The idea is I have 2 graphs and 2 buttons, each set is aligned to a bookmark, the Up bookmark shows the Improvement graph and the button switches to the Down bookmark. The Down bookmark shows the decline graph and the button switches to the Up bookmark.
I need to switch the Data filter off the bookmarks as the report has a number of filters that need to remain so I can't use filters to work this.
Is this possible or is there another way to achieve what I am attempting to do.
Many thanks.
