Forum Discussion
Button output based on condition
Hello all! Is the following possible, and if so, is someone able to help me?: I'm building a page where users can see all summarized costs per route. However these costs are based on multiple c...
Hi, Anonymous
Indeed, you are right! When using the bookmark type, you cannot apply fx expressions. Setting the button as page navigation and combining it with a measure is indeed an effective solution. In this way, when the user selects the slicer, the page jump can be achieved.
Measure = IF(HASONEFILTER(TestSlicer[Values]),"Page 2")When I don't have a slicer selected, I can't do the jump:
When I select the slicer, it jumps successfully:
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
- Create a Measure to Check Selection:
IsRouteSelected =
IF(
ISFILTERED(YourTable[Route]),
1,
0
) - Select the button on your page.
Go to the Format Button pane.
Under the Action section, turn on the action toggle.
Set the Action type to Bookmark (your pop-up bookmark). - In the same Action settings, click on the small fx (conditional formatting) icon next to Action.
Use the IsRouteSelected measure:
Set Field Value as the format type.
Select your IsRouteSelected measure.
The button will now only work when IsRouteSelected = 1.
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn