Forum Discussion
Button behavior similar to a drill through button
Hello everyone!
I am fairly new to PowerBI and I have been tasked to create a table and a button. The button should only be in an active state when a row in the table is selected. A behavior very similar to a drill through button. Any idea how to make this work?
I included screenshots below to better explain the situation:
In the screenshot above, we can see that the "See Details" button is inactive and we cannot click on it. I would like the "WEB" button to be the same.
Screenshot below shows that happens when a row is selected:
When row Q is selected, the "See Details" button is now active.
How can I get that type of behavior for the "WEB" button?
Any suggestions is greatly appreciated
Thank you
I understand, this is probably better for what you want...
https://www.youtube.com/watch?v=m4a2c55eXMU&ab_channel=BIElite
As far as enabling or disabling, I don't think technically possible, the fact you can change the formatting and text and that it won't navigate unless a value is selected is essentially "disabled".
I've thrown together a demo PBIX file if you prefer to learn by doing. See attached.
Select a name and the button will navigate, if none are selected it does nothing. Obviously you can change the text and formatting if none are selected, covered in the video.
3 Replies
- KNP
Super User
Hi Anonymous,
This is typically controlled with conditional formatting.
Check out this video.
https://www.youtube.com/watch?v=4Qy-bksqExI&ab_channel=GuyinaCube
I suggest watching it a few times as there is a lot of information in that video.
Let me know if you have any other specific questions.
Thanks for the response. It is a very interesting video. However, the button that would like to have exhibiting the drill through behavior is a "WEB URL" button, so technically it should be opening into a browser and not drill through to another page. Is there any way to "enable/disable" a button based on a DAX expression? The only thing I can seem to toy with are the colours.
- KNP
I understand, this is probably better for what you want...
https://www.youtube.com/watch?v=m4a2c55eXMU&ab_channel=BIElite
As far as enabling or disabling, I don't think technically possible, the fact you can change the formatting and text and that it won't navigate unless a value is selected is essentially "disabled".
I've thrown together a demo PBIX file if you prefer to learn by doing. See attached.
Select a name and the button will navigate, if none are selected it does nothing. Obviously you can change the text and formatting if none are selected, covered in the video.