How to Navigate to details report page with a single click on value instead of drill through option

[msft-cap]

Hi - I need to navigate from main page to details page (eg: I have multiple invoice numbers on main page and clicking on one invoice number should take me to details page where only that particular invoice details exist). 

Drill through will work in this case, but is there any solution so that just clicking on invoice number on main page will take to detail page. (instead of doing right click and then choosing drill through option)

Thanks

SS

[Anonymous · Accepted solution]

Hi  @msft-cap ,

After research, Power BI does not support this feature for the time being, but there are other methods you can try:

1. Use Toopltip. By moving the mouse to the column, the corresponding data will be displayed.

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-tooltips

2. Use hyperlinks as dynamic filters.

https://www.youtube.com/watch?v=EXObcA9G9Vw

Best Regards,

Liu Yang

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

[msft-cap]

Thank you, these are great alternatives to what I am looking for.

[parry2k]

@msft-cap unfortunately not, you can have a button that will get activated when an invoice is selected, so instead of using  right-click and then do the drill thru, a button on the report can take the user to the drill thru page, check the link on how this can be done Create a drillthrough button in Power BI - Power BI | Microsoft Docs

✨ Follow us on LinkedIn and  to our YouTube channel

Learn about conditional formatting at Microsoft Reactor

My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.