You will never do DRILLTHROUGH any other way in Power BI!
Рет қаралды 18,199
Ай бұрынLet me show you this amazing technique for doing drillthrough in Power BI. Easy to set up for you, easy to understand how to use for your audience.
Link to the video mentioned: • Make your tables look ...
Link to the learn article mentioned :learn.microsoft.com/en-us/pow...
Join this channel membership to get access to all the recorded bites as they become available:
/ @curbalen
Here you can download all the pbix files: curbal.com/donwload-center
SUBSCRIBE to learn more about Power and Excel BI!
/ @curbalen
Our PLAYLISTS:
- Join our DAX Fridays! Series: goo.gl/FtUWUX
- Power BI dashboards for beginners: goo.gl/9YzyDP
- Power BI Tips & Tricks: goo.gl/H6kUbP
- Power Bi and Google Analytics: goo.gl/ZNsY8l
☼☼☼☼☼☼☼☼☼☼
POWER BI COURSES:
Want to learn Power BI? How about you take one of our courses? Here you can find the available courses:
curbal.com/courses-overview
☼☼☼☼☼☼☼☼☼☼
ABOUT CURBAL:
Website: www.curbal.com
Contact us: www.curbal.com/contact
QUESTIONS? COMMENTS? SUGGESTIONS? You’ll find me here:
Linkedin ► goo.gl/3VW6Ky
Mastodon ► @ruthpozuelo@techhub.social
Twitter ► @curbalen
Facebook ► goo.gl/bME2sB
#CURBAL #SUBSCRIBE
@Baldur1005 Ай бұрын
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 Ай бұрын
Crazy that I dont show that! learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi-desktop
@ajaaskelainen Ай бұрын
I also loved the Matrix design !
@abhijeetghosh27 Ай бұрын
Brilliant idea 😊🤘
@mekidesbekele1787 21 күн бұрын
Thank you so much!
@Biconnector-Tableau-OBIEE Ай бұрын
Great video, thank you!
@CurbalEN Ай бұрын
🥳
@wisid Ай бұрын
Rad, hope to see this as a built in option for tables in the future
@CurbalEN Ай бұрын
Me too!! 😃
@ajaaskelainen Ай бұрын
Thank you 🙏
@zhiayuanwang5764 Ай бұрын
Wonderful!
@sleeprests Ай бұрын
Thank you! How would this work in conjunction with power bi service "Apps"?
@HachiAdachi Ай бұрын
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!
@CurbalEN Ай бұрын
Good point! Maybe with an OR statement you can get around that?
@visheshjjain Ай бұрын
Please can you post the link to the dashboard video, can’t find it in the playlist. Thanks Ruth!
@vamshiabhilash Ай бұрын
salla krley na bay thu kya babby hey ka
@samcaseybolade5368 Ай бұрын
Thanks for this video @curbal . I suppose you may want to bookmark the default view to go back to the original state.
@CurbalEN Ай бұрын
Yes :)
@SpanishPowerBI Ай бұрын
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.
@CurbalEN Ай бұрын
Aqui tienes como! learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi-desktop
@SpanishPowerBI Ай бұрын
@@CurbalEN ¡Muchas gracias Ruth!
@benhalicki9749 Ай бұрын
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 :)
@CurbalEN Ай бұрын
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
@benhalicki9749 Ай бұрын
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 :)
@CurbalEN Ай бұрын
@benhalicki9749 You can do that with my trick
@CurbalEN Ай бұрын
@benhalicki9749 You can do that with my trick, uou dont need to add a new column :)
@cameronweston1038 Ай бұрын
Good idea wish it would work with a graph. Also in desktop mode?
@CurbalEN Ай бұрын
Agree!
@spen2431 Ай бұрын
💥Thanks for sharing💥. One comment, I always hide the filters pane, how can i set a back button to clear out the applied filter?
@CurbalEN Ай бұрын
The drillthrough back button seems to clear the filters :)
@spen2431 Ай бұрын
@@CurbalEN I probably should have tried it myself first.. Thanks as always
@janoscahana7509 Ай бұрын
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 Ай бұрын
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
@mienzillaz Ай бұрын
@@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
@CurbalEN Ай бұрын
@mienzillaz it is not intuitive at all. Most users get frustrated with buttons that you can not click :(
@mienzillaz Ай бұрын
@@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.
@CurbalEN Ай бұрын
Great job! If the users understand what it is and how to use it then it is great :)
@tuomaslaaksonen3396 Ай бұрын
That is amazing, any idea if this can be replicated without rendering the report all over, so it would navigate to the page?
@CurbalEN Ай бұрын
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
@swethasuresh-cz4fg 28 күн бұрын
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?
@andreiamador4894 Ай бұрын
Saluditos desde Costa Rica, Ruth! Buen vídeo como siempre!
@CurbalEN Ай бұрын
Gracias y saludos!
@oriby1 Ай бұрын
Tnx 🙏🏽 does it work in pbi server also?
@CurbalEN Ай бұрын
I dont know, let us know if you try!
@ankurkhaparde6641 Ай бұрын
Yes it does work!
@CurbalEN Ай бұрын
@ankurkhaparde6641 🥳🥳🥳 Thanks for reporting !
@Dims94 Ай бұрын
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.
@CurbalEN Ай бұрын
Yeah, all hacks are like that, but despite that, this drillthrough is better. Fingers crossed they will implement it without the shortcomings :(
@mariagamboa1458 7 күн бұрын
Can you do that but to go to another page in another report published in the same workspace?
@CurbalEN 7 күн бұрын
Yes, you should!
@emujkic Ай бұрын
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?
@CurbalEN Ай бұрын
Known issue I am afraid! community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607#M167737
@jin0616 Ай бұрын
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?
@CurbalEN Ай бұрын
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
@Harpreet06 Ай бұрын
1 question, bit confused, how did the drill through url measure apply to the drill through text?
@CurbalEN Ай бұрын
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
@datawhipper 20 күн бұрын
Hi Ruth, do you have the video for the trick in 1:04?
@CurbalEN 19 күн бұрын
It is in the video description :)
@hiteshshah2849 29 күн бұрын
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
@CurbalEN 29 күн бұрын
Check the URL , probably something wrong there!
@Biconnector-Tableau-OBIEE Ай бұрын
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.
@CurbalEN Ай бұрын
Never used tableau, so I am afraid it is not possible :(
@rajishn Ай бұрын
Can this be done in powerbi desktop
@CurbalEN Ай бұрын
If you mean open the links in power bi desktop i am afraid it is not
@geneee Ай бұрын
Is there a way to automatically remove the selected country when going back to first page?
@CurbalEN Ай бұрын
It should be possible…wil check!
@mcnater Ай бұрын
@@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.
@CurbalEN Ай бұрын
@mcnater thanks for the tips :)
@sanchowitfurrows1561 Ай бұрын
I've got an impression that link opens in a new tab in browser, does it?
@CurbalEN Ай бұрын
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
@travelkare Ай бұрын
Please make detailed video on same, didnt get proper understanding in this.
@shaun-zr8cs Ай бұрын
Only the field filtering of the current table can be passed, but the surrounding filtering environment cannot be passed
@CurbalEN Ай бұрын
Build the URL with the filters you need!
@sidharajjadeja5004 Ай бұрын
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
@CurbalEN Ай бұрын
Just use the back buttom from drillthrough, it will remove the filters
HIMAWARIちゃんねる
Рет қаралды 21 МЛН
Maven Analytics
Рет қаралды 27 М.