Forum Discussion
Solved
Is there a SELECTED button DAX function?
Hi Experts! I have a report with 3 slicers: A, B, and C. However, at any given time, I want only one of the three slicers to be visible/shown while the remaining two are hidden because the slicer...
When you're working with bookmarks you can have them remember the state of filters, slicers etc.
You could create a disconnected table containing rows for button A, B & C. When the appropriate button is active make sure that a filter is applied on the disconnected table and at the same time clear the selections on the other slicers. You can then use SELECTEDVALUE on the disconnected table to determine which button is active.
Hi johnt75 ,
Perfect! That worked! I was pondering a solution and came up with that on my own. After configuring, testing, and confirming that it works, I was going to post back here my solution.
But, since you posted the same solution, I will mark yours as the solution!
Thanks and kudos!