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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Abhishekjsrwala
Frequent Visitor

Urgent but Interesting Page Navigation/ Drill Through Use Case

Hi All,

There is an interesting use case my client wants:
He wants to drill through each row, by clicking only the "Learn More" Button (the no of rows is 50k+)

Abhishekjsrwala_1-1672160915911.png

I have tried the following:

  1. Drill down using Modern Tooltip --Rejected

  2. Drill Down using Button - Rejected

  3. Drill Down using Conditional parameters passed through Hyperlink -- rejected(See below image)

 
Abhishekjsrwala_3-1672160953372.png

What I need - Only, a button across each row to drill through, maybe a text column saying learn more that can be used as drill through (only this column should reflect the drill through functionality.) This Learn More Text column should be freezed and should not move with horizontal scroll (I know matrix chart has this freezing functionality for Rows inputs)

 

I am open to all kinds of crazy suggestions, as long as it remains in the scope of PBI.

PS: I am very good in PBI and hence all the native solutions have been tried and implemented (and rejected).

Thanks.

 

1 ACCEPTED SOLUTION
MFelix
Super User
Super User

Hi @Abhishekjsrwala ,

 

Do you want to have something similar to this?

 

MFelix_0-1672163017980.png

 

The option I can see is to use a base64 image and connect your drill trough by weblink to that column that way appears to be a button. 

 

http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html

 

Another option can be to use a custom visual:

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=table&page=1

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200001457?tab=Overview

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



View solution in original post

5 REPLIES 5
MFelix
Super User
Super User

Hi @Abhishekjsrwala ,

 

Do you want to have something similar to this?

 

MFelix_0-1672163017980.png

 

The option I can see is to use a base64 image and connect your drill trough by weblink to that column that way appears to be a button. 

 

http://sqljason.com/2018/01/embedding-images-in-power-bi-using-base64.html

 

Another option can be to use a custom visual:

https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=table&page=1

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200001457?tab=Overview

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Sounds Interesting, Can you provide some reference for the second part of your answer?
"connect your drill trough by weblink to that column that way appears to be a button."

Thanks

Hi @Abhishekjsrwala ,

 

That is the exact option you have placed in the last part of your post:

MFelix_0-1672164086912.png

 

But instead of showing the link image you show the base 64.

 

 


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Okay, 2 things here:
1. Do you know how to add drill through to only one column in Acterys Table Edit custom visual.
2. Also, using your approach by drilled pages will open in new tab(Everytime).I do not want that

Hi @Abhishekjsrwala ,

 

I haven't use the Acterys Table visualization, so I cannot tell you what you need.

 

Regarding the second question believe that is not possible,but you can check if the answer on this post is correct or not, people are refering that is not but something can have changed.

https://community.powerbi.com/t5/Desktop/Using-hyperlink-and-open-in-the-same-tab/m-p/771697


Regards

Miguel Félix


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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