Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
touseef2660
Helper I
Helper I

How 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 screenshot the drill through button is visible and greyed out icon and background color white:

touseef2660_0-1713317338649.png

And When I click any bar it will be visible with black icon color:

touseef2660_1-1713317423041.png

 

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.

 



 

1 ACCEPTED SOLUTION
touseef2660
Helper I
Helper I

I found the solution. Just choose state to "Disabled" under style and then change the icon and fill colors.

touseef2660_0-1713333964023.png

touseef2660_1-1713334048334.png

 

View solution in original post

3 REPLIES 3
touseef2660
Helper I
Helper I

I found the solution. Just choose state to "Disabled" under style and then change the icon and fill colors.

touseef2660_0-1713333964023.png

touseef2660_1-1713334048334.png

 

Ritaf1983
Super User
Super User

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 :

button color = if (HASONEVALUE('Calendar'[Date]),"Black","#F5C4AF")
Ritaf1983_0-1713322775157.pngRitaf1983_1-1713322811403.png

To get the result in the icon color use the conditional formatting option by field value

Ritaf1983_2-1713322887246.png

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:

touseef2660_0-1713329076774.png

 

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.