Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 screenshot the drill through button is visible and greyed out icon and background color white:
And When I click any bar it will be visible with black icon color:
Is it possible to not show the greyed out icon when no bar is clicked? And is it possible on a colored canvas background?
@Greg_Deckler , @lbendlin Please help me if you know the solution.
Solved! Go to Solution.
I found the solution. Just choose state to "Disabled" under style and then change the icon and fill colors.
I found the solution. Just choose state to "Disabled" under style and then change the icon and fill colors.
Hi @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 :
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
Sorry 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:
User | Count |
---|---|
103 | |
87 | |
77 | |
70 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |