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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

Power BI Show/hide bookmark buttons based on selection

Hello,

 

I have a bar chart that displays all of my customers, by sales. When I select a customer from the bar chart, I would like to display a bookmark button that will take the user to a new page. I can accomplish this fine using the drill-down process, but my users are very computer illterate. How do I show a bookmark button based on a user selection?

 

Cheers,

 

Peter

1 ACCEPTED SOLUTION
mahoneypat
Microsoft Employee
Microsoft Employee

Please see this article that seems to be just what you are looking to do.

Create a drill-through button in Power BI - Power BI | Microsoft Docs

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

4 REPLIES 4
v-robertq-msft
Community Support
Community Support

Hi, @Anonymous 

According to your description, I think you can achieve this using measure and conditional format for icon color in Power BI to achieve this, you can try my steps:

  1. Create a measure:
Make_Transparent =

IF(hasoneFILTER('Table'[ID]),"Black","#FFFFFF00")
  1. Create a button and go to the icon set, then set like this:

v-robertq-msft_0-1612506167957.png

 

v-robertq-msft_1-1612506167962.png

 

  1. And you can get what you want, like this:

v-robertq-msft_2-1612506167971.png

 

v-robertq-msft_3-1612506167972.png

 

What’s more, you can also go to the action of the button and click here to set different page navigation for each user using the same method:

v-robertq-msft_4-1612506167975.png

 

You can download my test pbix file here

 

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

 

Best Regards,

Community Support Team _Robert Qin

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

mahoneypat
Microsoft Employee
Microsoft Employee

Please see this article that seems to be just what you are looking to do.

Create a drill-through button in Power BI - Power BI | Microsoft Docs

Pat

 





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


lbendlin
Super User
Super User

Reduce your requirement from "I need a bookmark button" to "I need a button".  And then reduce it again to "I need a hyperlink that may or may not look like a button".  Those are much easier to implement.

Anonymous
Not applicable

Hello,

 

   Thank you for the reply, but I do not understand your comment. When a user clicks on any-one of the bars in my bar chart, I would like a button to become visible.

 

Cheers,

 

Peter

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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