Forum Discussion
touseef2660
Helper I
Helper IHow to show drill through button only when graph's bar is clicked. Otherwise it should be hidden?
I want to keep the drill through button hidden on a colored canvas background when I am not clicking on the Bar of the graph. It should only visible to me when I click the bar. For eg in this scree...
I found the solution. Just choose state to "Disabled" under style and then change the icon and fill colors.
Ritaf1983
Super User
Super UserHi touseef2660
You can create a measure that checks if the selection was made and returns for example black if yes and the color of your canvas if not.
For example :
button color = if (HASONEVALUE('Calendar'[Date]),"Black","#F5C4AF")
To get the result in the icon color use the conditional formatting option by field value
pbix is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
touseef2660Helper I
Helper ISorry my question was specifically for drill through button. If you change the action of the button to "drill through" in your dashboard you will see the button grey color and the dax function will not work. Please check the screenshot below: