I missed this in video... but where did you put this Drillthrough URL measure. It looks like magically you create this and didn't put in anywhare and "More" becomes hyperlink
@@CurbalEN Have you figured out, how to convert Multi word columns to it? I cannot figure it out and I follow documentation to the letter colume is [Name for KPI Scorecard]. Did _x0020_ and %20 without much success
Nice! 😀 MUCH better than the default drillthrough method(s). I will have to give it a try, but I assume you would have to customize the drillthrough measure for each workspace if a report is published to multiple workspaces? 🤔 Thanks, Ruth!
Hi, Thanks for the video! One question, if the user has filtered the report by a dimension that is not part of the table, then this won't work, correct?. Meaning, unless I manually add all the possible columns to the URL, then the landing page wont have all the filters? Thanks!
Thank you for showing this. But I get the error stating - "This field was deleted from the model and can't be used as filter" in the filter pane, but I have this field- available in the model. Can you help?
Hi Ruth, is this opening a new browser window or new tab each time you click on the link? I haven't tried your trick yet, but was looking at something similar about 12 months ago. The annoying thing was that it would open each link in a new tab, but really all I wanted to be able to do was to have a link in a table that linked to a page in the same report :)
Unfortunately, links open in new tabs. If they fix that then it is possible. community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607/highlight/true
I would really like to see the same drill through functionality implemented so we can use as a link, rather than a right click. That way it would work in desktop as well :)
Nice. I wish though that it did not open a new tab with each drillthrough. When you use the standard way, you will keep working in the same report / tab.
@@CurbalEN got you. I was using this successfully on KPI grid, which was still matrix but with some magic behind it. Users could select KPI and then button is activated to take them to the details.
Hola Ruth. Un vídeo súper interesante. Tengo una pregunta, ¿cómo conviertes la medida More en un enlace url? ¿Dónde añades la medida que contiene la url a la página? Gracias.
Thanks for this trick. I tried this long back for a customer but only problem was every time it opens a new tab. Another thing I was trying is to filter a slicer in the detailed page using the parameter which was also not possible.
If I embed this report, the link won’t work or it is going back to non embed version of the report. Anyway to solve the issue on the embedded report link?
Unfortunately, links open in new tabs. If they fix that then it is possible. community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607/highlight/true
Are special characters in the country name automatically escaped with this method, or is that an extra step you would need to take when generating the URL?
Hi better than the std drill through. OK when accessing an app directly in the service but if you access power bi throught Teams ive found URLs navigate you out of teams and opens in your browser thanks
Some PRO's and CON's to this technique (correct me if I'm wrong) PRO: You can click through using just the left mouse button from within the object itself (no need for right-clicking => drill-through => Report ...). PRO: You're essentially setting a filter for "All pages," so the filter from that point is automatically preserved (exact functionality I was looking for). CON: You're actually loading the entire report, which takes significantly longer than a regular drill-through. CON: Links open in a new tab (this could also be a PRO since it allows you to select another project more quickly). CON: The URL experience only works in Power BI Service, not on the desktop, making it harder to test. CON: The "All pages" filter is applied on top of any existing filters. It's important that no filters on the requested field are active when the report is published; otherwise, you might end up with no data (e.g., Project Name = "a" + Project Name = "b" => no result because a project name can't be two things at once). CON: You can only set a URL after the report has been published (because you need to know the link). CON: When you navigate back to the overview, the filter is ALSO remembered, so either: The user needs to manually remove the filter, or you need to guide the user back via a button (again using a URL, this time without the filter). In this case, it's best to hide most pages. CON: The entire "page navigation" system gets to be unusable because the filters are not added/removed properly. PRO: Since you're loading the entire report anyway, you might as well work with different small reports linked together. This allows different people to work simultaneously on different parts.
It is a hack so as you mention it has some drawbacks, but in some cases it os pretty neat! I hope MS takes inpiration and implements it in the product.
Unfortunately, links open in new tabs. If they fix that then it is possible. community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607/highlight/true
@@CurbalEN It will if you use a Back button. This is why on any drill thrus I create...I always have it be a drill through page ONLY...no slicers...no anything a user can click on to get lost...the only thing they can do is hit the Back button to go back where they came from. Oh and HIDE the drill thru page so they cannot click on Summary.
How in the heck did you get Drillthrough URL into the visual???? I've watched this video 6 times and I can't see how you did it. You also fail to mention that the link opens a new browser tab.
I liked this idea, but wouldn’t it be more annoying for users to have to go back to the previous page and remove the filter from the pane? They’d want the filter to be removed when navigating the page
I missed this in video... but where did you put this Drillthrough URL measure. It looks like magically you create this and didn't put in anywhare and "More" becomes hyperlink
Crazy that I dont show that!
learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi-desktop
@@CurbalEN Have you figured out, how to convert Multi word columns to it? I cannot figure it out and I follow documentation to the letter colume is [Name for KPI Scorecard]. Did _x0020_ and %20 without much success
I also loved the Matrix design !
Amazing!
Finaly found the feature in SSRS in Power BI
Thank you
Rad, hope to see this as a built in option for tables in the future
Me too!! 😃
Ahhh I'm so excited to try this!!
Thank you!
How would this work in conjunction with power bi service "Apps"?
Nice! 😀 MUCH better than the default drillthrough method(s). I will have to give it a try, but I assume you would have to customize the drillthrough measure for each workspace if a report is published to multiple workspaces? 🤔 Thanks, Ruth!
Good point! Maybe with an OR statement you can get around that?
I am having certain slicer in that page then how to navigate back to main page with same slicer selection is that possible
I have created the url but after the navigation I want to return to main but i am having certain slicer How can i apply those filters
Hi, Thanks for the video! One question, if the user has filtered the report by a dimension that is not part of the table, then this won't work, correct?. Meaning, unless I manually add all the possible columns to the URL, then the landing page wont have all the filters? Thanks!
Thank you for showing this. But I get the error stating - "This field was deleted from the model and can't be used as filter" in the filter pane, but I have this field- available in the model. Can you help?
Thanks for this video @curbal . I suppose you may want to bookmark the default view to go back to the original state.
Yes :)
how to do it on multiple columns, here only given one column. Can you provide url if we pass three columns as filter
Thank you so much!
Hi Ruth, is this opening a new browser window or new tab each time you click on the link? I haven't tried your trick yet, but was looking at something similar about 12 months ago. The annoying thing was that it would open each link in a new tab, but really all I wanted to be able to do was to have a link in a table that linked to a page in the same report :)
Unfortunately, links open in new tabs. If they fix that then it is possible.
community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607/highlight/true
I would really like to see the same drill through functionality implemented so we can use as a link, rather than a right click. That way it would work in desktop as well :)
@benhalicki9749 You can do that with my trick
@benhalicki9749 You can do that with my trick, uou dont need to add a new column :)
Brilliant idea 😊🤘
💥Thanks for sharing💥. One comment, I always hide the filters pane, how can i set a back button to clear out the applied filter?
The drillthrough back button seems to clear the filters :)
@@CurbalEN I probably should have tried it myself first.. Thanks as always
great job.. quick question.. how can we send set of values to drill through report
Please can you post the link to the dashboard video, can’t find it in the playlist. Thanks Ruth!
salla krley na bay thu kya babby hey ka
Hi Ruth, do you have the video for the trick in 1:04?
It is in the video description :)
Nice. I wish though that it did not open a new tab with each drillthrough. When you use the standard way, you will keep working in the same report / tab.
Agree, it has been requested for years :
community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607/highlight/true
@@CurbalEN
Why not to use a single button solution????
Assign drill on a button based on selection. EZ and no more issue with new windows/tabs
@mienzillaz it is not intuitive at all. Most users get frustrated with buttons that you can not click :(
@@CurbalEN got you. I was using this successfully on KPI grid, which was still matrix but with some magic behind it. Users could select KPI and then button is activated to take them to the details.
Great job! If the users understand what it is and how to use it then it is great :)
Hola Ruth. Un vídeo súper interesante. Tengo una pregunta, ¿cómo conviertes la medida More en un enlace url? ¿Dónde añades la medida que contiene la url a la página? Gracias.
Aqui tienes como!
learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi-desktop
@@CurbalEN ¡Muchas gracias Ruth!
Can you do that but to go to another page in another report published in the same workspace?
Yes, you should!
Is there any way to navigate to page in same window instead of opening new tab?
Nope :(
Great video, thank you!
🥳
Thanks for this trick. I tried this long back for a customer but only problem was every time it opens a new tab. Another thing I was trying is to filter a slicer in the detailed page using the parameter which was also not possible.
Yeah, all hacks are like that, but despite that, this drillthrough is better. Fingers crossed they will implement it without the shortcomings :(
Good idea wish it would work with a graph. Also in desktop mode?
Agree!
1 question, bit confused, how did the drill through url measure apply to the drill through text?
It just showed up in the demo so i forgot to show it:
learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables
If I embed this report, the link won’t work or it is going back to non embed version of the report. Anyway to solve the issue on the embedded report link?
Hi,
Is this matrix design a background image? :)
It is !
m.th-cam.com/video/97M-D5WXaqI/w-d-xo.html
@@CurbalEN Thanks!!! (from Brasil)
Obrigada :)
Thank you 🙏
Saluditos desde Costa Rica, Ruth! Buen vídeo como siempre!
Gracias y saludos!
Thnx for idea. However I have issue with solution, since it is always opening in new tab. Do you have idea how we could change this?
Known issue I am afraid!
community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607#M167737
is it possible to go to drillthrough page on the same window/tab instead of opening a new window/tab when clicking the "More" link?
Unfortunately, links open in new tabs. If they fix that then it is possible.
community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607/highlight/true
Are special characters in the country name automatically escaped with this method, or is that an extra step you would need to take when generating the URL?
Hi better than the std drill through. OK when accessing an app directly in the service but if you access power bi throught Teams ive found URLs navigate you out of teams and opens in your browser thanks
Yeah, hacks are like that, they kind of work but with limitations. I hope MS implements this !
Could you do a video on Power BI vs Tableau? We published a video about it and would love to hear your point of view.
Never used tableau, so I am afraid it is not possible :(
Some PRO's and CON's to this technique (correct me if I'm wrong)
PRO: You can click through using just the left mouse button from within the object itself (no need for right-clicking => drill-through => Report ...).
PRO: You're essentially setting a filter for "All pages," so the filter from that point is automatically preserved (exact functionality I was looking for).
CON: You're actually loading the entire report, which takes significantly longer than a regular drill-through.
CON: Links open in a new tab (this could also be a PRO since it allows you to select another project more quickly).
CON: The URL experience only works in Power BI Service, not on the desktop, making it harder to test.
CON: The "All pages" filter is applied on top of any existing filters. It's important that no filters on the requested field are active when the report is published; otherwise, you might end up with no data (e.g., Project Name = "a" + Project Name = "b" => no result because a project name can't be two things at once).
CON: You can only set a URL after the report has been published (because you need to know the link).
CON: When you navigate back to the overview, the filter is ALSO remembered, so either: The user needs to manually remove the filter, or you need to guide the user back via a button (again using a URL, this time without the filter). In this case, it's best to hide most pages.
CON: The entire "page navigation" system gets to be unusable because the filters are not added/removed properly.
PRO: Since you're loading the entire report anyway, you might as well work with different small reports linked together. This allows different people to work simultaneously on different parts.
It is a hack so as you mention it has some drawbacks, but in some cases it os pretty neat!
I hope MS takes inpiration and implements it in the product.
Wonderful!
i tried one of my reports but the filter is not working to redirect the page every time the new page opens but corresponding details are not coming
Check the URL , probably something wrong there!
That is amazing, any idea if this can be replicated without rendering the report all over, so it would navigate to the page?
Unfortunately, links open in new tabs. If they fix that then it is possible.
community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607/highlight/true
I've got an impression that link opens in a new tab in browser, does it?
Unfortunately, links open in new tabs:
community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607/highlight/true
Can this be done in powerbi desktop
If you mean open the links in power bi desktop i am afraid it is not
Tnx 🙏🏽 does it work in pbi server also?
I dont know, let us know if you try!
Yes it does work!
@ankurkhaparde6641 🥳🥳🥳 Thanks for reporting !
For me filter is not happening can anyone help😢
Thank uuuu jeee
Is there a way to automatically remove the selected country when going back to first page?
It should be possible…wil check!
@@CurbalEN It will if you use a Back button. This is why on any drill thrus I create...I always have it be a drill through page ONLY...no slicers...no anything a user can click on to get lost...the only thing they can do is hit the Back button to go back where they came from. Oh and HIDE the drill thru page so they cannot click on Summary.
@mcnater thanks for the tips :)
Please make detailed video on same, didnt get proper understanding in this.
How in the heck did you get Drillthrough URL into the visual???? I've watched this video 6 times and I can't see how you did it. You also fail to mention that the link opens a new browser tab.
Only the field filtering of the current table can be passed, but the surrounding filtering environment cannot be passed
Build the URL with the filters you need!
I liked this idea, but wouldn’t it be more annoying for users to have to go back to the previous page and remove the filter from the pane? They’d want the filter to be removed when navigating the page
Just use the back buttom from drillthrough, it will remove the filters