Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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:
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
84 | |
84 | |
65 | |
62 | |
55 |
User | Count |
---|---|
171 | |
109 | |
105 | |
73 | |
71 |