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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric 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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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