Forum Discussion
Button output based on condition
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.
Hi Anonymous - Instead of creating two separate buttons, you can apply conditional formatting to the button’s Action settings. Go to the button’s Action properties, set Action to On, and select a conditional formatting rule that links it to the RouteSelected measure. If RouteSelected equals 1, the action can be linked to the bookmark, but if it equals 0, it will not perform any action.
This approach requires careful configuration, but it will prevent users from clicking the button when it is irrelevant.
I do not have the formula button in the actionfield...
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.