Urgent but Interesting Page Navigation/ Drill Through Use Case

[Abhishekjsrwala]

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+)

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)

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.

[MFelix · Accepted solution]

Hi @Abhishekjsrwala ,

Do you want to have something similar to this?

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

[Abhishekjsrwala]

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

[MFelix]

Hi @Abhishekjsrwala ,

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

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

[Abhishekjsrwala]

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

[MFelix]

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