You will never do DRILLTHROUGH any other way in Power BI!

Подписаться 134 тыс.

Просмотров 20 тыс.

50% 1

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

Опубликовано:

23 апр 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 85

@Baldur1005 2 месяца назад

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 2 месяца назад

Crazy that I dont show that! learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi-desktop

@ajaaskelainen 2 месяца назад

I also loved the Matrix design !

@abhijeetghosh27 2 месяца назад

Brilliant idea 😊🤘

@mekidesbekele1787 Месяц назад

Thank you so much!

@Biconnector-Tableau-OBIEE 2 месяца назад

Great video, thank you!

@CurbalEN 2 месяца назад

🥳

@ajaaskelainen 2 месяца назад

Thank you 🙏

@wisid 2 месяца назад

Rad, hope to see this as a built in option for tables in the future

@CurbalEN 2 месяца назад

Me too!! 😃

@zhiayuanwang5764 2 месяца назад

Wonderful!

@sleeprests 2 месяца назад

Thank you! How would this work in conjunction with power bi service "Apps"?

@nafeesahmed2642 2 дня назад

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?

@HachiAdachi 2 месяца назад

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 2 месяца назад

Good point! Maybe with an OR statement you can get around that?

@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 :)

@andreiamador4894 2 месяца назад

Saluditos desde Costa Rica, Ruth! Buen vídeo como siempre!

@CurbalEN 2 месяца назад

Gracias y saludos!

@janoscahana7509 2 месяца назад

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 2 месяца назад

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 2 месяца назад

@@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 2 месяца назад

@mienzillaz it is not intuitive at all. Most users get frustrated with buttons that you can not click :(

@mienzillaz 2 месяца назад

@@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 2 месяца назад

Great job! If the users understand what it is and how to use it then it is great :)

@SpanishPowerBI 2 месяца назад

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 2 месяца назад

Aqui tienes como! learn.microsoft.com/en-us/power-bi/create-reports/power-bi-hyperlinks-in-tables?tabs=powerbi-desktop

@SpanishPowerBI 2 месяца назад

@@CurbalEN ¡Muchas gracias Ruth!

@Dims94 2 месяца назад

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 2 месяца назад

Yeah, all hacks are like that, but despite that, this drillthrough is better. Fingers crossed they will implement it without the shortcomings :(

@Biconnector-Tableau-OBIEE 2 месяца назад

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 2 месяца назад

Never used tableau, so I am afraid it is not possible :(

@nomad9296 7 дней назад

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

@CurbalEN 7 дней назад

Yeah, hacks are like that, they kind of work but with limitations. I hope MS implements this !

@visheshjjain 2 месяца назад

Please can you post the link to the dashboard video, can’t find it in the playlist. Thanks Ruth!

@vamshiabhilash 2 месяца назад

salla krley na bay thu kya babby hey ka

@cameronweston1038 2 месяца назад

Good idea wish it would work with a graph. Also in desktop mode?

@CurbalEN 2 месяца назад

Agree!

@spen2431 2 месяца назад

💥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 2 месяца назад

The drillthrough back button seems to clear the filters :)

@spen2431 2 месяца назад

@@CurbalEN I probably should have tried it myself first.. Thanks as always

@tuomaslaaksonen3396 2 месяца назад

That is amazing, any idea if this can be replicated without rendering the report all over, so it would navigate to the page?

@CurbalEN 2 месяца назад

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 Месяц назад

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?

@mariagamboa1458 Месяц назад

Can you do that but to go to another page in another report published in the same workspace?

@CurbalEN Месяц назад

Yes, you should!

@benhalicki9749 2 месяца назад

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 2 месяца назад

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 2 месяца назад

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 2 месяца назад

@benhalicki9749 You can do that with my trick

@CurbalEN 2 месяца назад

@benhalicki9749 You can do that with my trick, uou dont need to add a new column :)

@EncontroLegionarioOficial 9 дней назад

Hi, Is this matrix design a background image? :)

@CurbalEN 9 дней назад

It is ! m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-97M-D5WXaqI.html

@EncontroLegionarioOficial 9 дней назад

@@CurbalEN Thanks!!! (from Brasil)

@CurbalEN 8 дней назад

Obrigada :)

@emujkic 2 месяца назад

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 2 месяца назад

Known issue I am afraid! community.fabric.microsoft.com/t5/Service/Power-BI-Web-url-to-open-in-same-window/m-p/2664607#M167737

@catherinegrant7890 27 дней назад

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?

@jin0616 2 месяца назад

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 2 месяца назад

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

@shaun-zr8cs 2 месяца назад

Only the field filtering of the current table can be passed, but the surrounding filtering environment cannot be passed

@CurbalEN 2 месяца назад

Build the URL with the filters you need!

@travelkare 2 месяца назад

Please make detailed video on same, didnt get proper understanding in this.

@Harpreet06 2 месяца назад

1 question, bit confused, how did the drill through url measure apply to the drill through text?

@CurbalEN 2 месяца назад

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

@hiteshshah2849 Месяц назад

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 Месяц назад

Check the URL , probably something wrong there!

@oriby1 2 месяца назад

Tnx 🙏🏽 does it work in pbi server also?

@CurbalEN 2 месяца назад

I dont know, let us know if you try!

@ankurkhaparde6641 2 месяца назад

Yes it does work!

@CurbalEN 2 месяца назад

@ankurkhaparde6641 🥳🥳🥳 Thanks for reporting !

@datawhipper Месяц назад

Hi Ruth, do you have the video for the trick in 1:04?

@CurbalEN Месяц назад

It is in the video description :)

@sanchowitfurrows1561 2 месяца назад

I've got an impression that link opens in a new tab in browser, does it?

@CurbalEN 2 месяца назад

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

@rajishn 2 месяца назад

Can this be done in powerbi desktop

@CurbalEN 2 месяца назад

If you mean open the links in power bi desktop i am afraid it is not

@geneee 2 месяца назад

Is there a way to automatically remove the selected country when going back to first page?

@CurbalEN 2 месяца назад

It should be possible…wil check!

@mcnater 2 месяца назад

@@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 2 месяца назад

@mcnater thanks for the tips :)

@sidharajjadeja5004 2 месяца назад

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 2 месяца назад

Just use the back buttom from drillthrough, it will remove the filters