Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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 costlines, such as transport, admin, fuel etc. Next to the table I have placed an 'Information button' wich leads to a bookmark showing a pop-up containing a table with all these costlines regarding the selected route. As you may understand, I do not want the user be able to press te button if there is no route selected.
Currently, I formatted the color of the button to be the same color as the background so it is not visible. However, when the mouse is hovering it's still clickable. Preferred is that this button is only clickable when a route is selected. Is this possible?
If more info needed, please ask me!
Thank you in advance!
Solved! Go to Solution.
Hi, @bnjmnnl
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.
IsRouteSelected =
IF(
ISFILTERED(YourTable[Route]),
1,
0
)
💌 If this helped, a Kudos 👍 or Solution mark would be great! 🎉
Cheers,
Kedar
Connect on LinkedIn
Hi @bnjmnnl - 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.
Proud to be a Super User! | |
I do not have the formula button in the actionfield...
Hi, @bnjmnnl
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
146 | |
75 | |
64 | |
52 | |
47 |
User | Count |
---|---|
218 | |
88 | |
73 | |
64 | |
60 |