Відео

Hi thanks for your question. The new version of Power BI does continue to support drill-through. Check out this learn article from MSFT for some foundational info, hope this helps and thanks for your support! learn.microsoft.com/en-us/power-bi/create-reports/desktop-drillthrough

Thank you bro I am subscribing you now good explanation

Thank you for both the question and compliment, I'm happy to hear you found the video to be great! I appreciate the summarized description of the problem, unfortunately offhand I'm not deeply familiar with the xViz Performance Flow component. I'm unfortunately unsure how to solve your xViz issue without a deep dive.

@@PowerBIBro I appreciate you getting back to me. I did get the issue resolved. Will it be ok if I link to the solution video from here?

@wajiharehman9011 that’ll be great!

Hi thank you for your question! Connecting images from OneDrive can be slightly nuanced, I've added it to my list to create a video on how to do it. Here's some high-level documentation from Microsoft to hopefully help. There are also some MSFT community blog posts on the subject. Display images in a table, matrix, or slicer in a report learn.microsoft.com/en-us/power-bi/create-reports/power-bi-images-tables

@@PowerBIBro thank you... I have done some more investigations, and I think it is because my organisation does not allow us to make the shared link public/anonymous accessible and therefor the picture will not show up in Power BI(?)

Thanks for your question and I appreciate you sharing! These types of issues are typically associated with the steps performed at the point in which the hierarchy itself is created (right clicking and adding fields). It may be beneficial to go back and watch the below step, ensuring you add/build the layers in your hierarchy field utilizing the correct order as the order in which fields are added define the order in which they drill to. 18:46 - Create a hierarchy and create hierarchy measures

Thank you so much!!

Thanks for the question! I've reviewed the below docs from MSFT and it doesn't seem list any data size limitation, but I think visuals may have 1k limit on number of items they can display in general. Can you elaborate a bit more on your issue? Is it that it doesn't render at all, or some fields are limited etc..more details the better. learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-influencers?tabs=powerbi-desktop

Thank you for sharing and I’m happy to hear this feedback!!!

Appreciate your question and thanks for reaching out! You can open a report by clicking "Open" on the HOME screen (on the left under "Home"). This will take you to a screen where you can browse and open any desired report. Check out this documentation below for a summary of the home screen. learn.microsoft.com/en-us/power-bi/create-reports/desktop-home

Thank you for sharing!!!

100% it can definitely work that way and thanks for your question! When you go to setup the filter of the subscription, select your customer dimension and you’ll be all set!!

Most certainly! To use zip codes in maps, you’ll want to set the data type of the zip code to geographical

Thank you for sharing and glad to hear that it helped you out!!!

Thank you!! This compliment made my day and I am grateful that you shared it. This is an uplifting message and I am thankful for your support! Please share with friends!!!

You are very correct and great job figuring that out!!! I should have included that step in the video. Appreciate your support!!!

You don't know how this information just saved me the stress of trying to figure out how to solve same issue. Thanks

Thank you for sharing and thank you for your support!!

Thanks for your support and this question! Offhand I think it may have just been coincidence, but it may be valuable to toggle the default interaction of your report highlight/cross-filter.

Thanks for the question and I will be happy to help! I’m 100% certain which part of the video you are referring to, will you provide a timestamp which contains the filters you’re describing? Looking forward to helping!!

Thanks for your support and great question! That’s a tough one, offhand I don’t have a guaranteed solution. Something I’ve done in the past is create conditional formatting which changes the font color to the same color as the background if the value = 0. This would give the appearance the column was empty but still had a space, better than all 0’s though. Let me know what you land on!

@PowerBIBro Thanks for the suggestion! Didn't think about that one, but what I ended up doing was just minimizing the columns until they're almost not visible. It got the job done but wasn't the cleanest, unfortunately. I'll let you know if I find a better solution though. Thanks again for the walkthrough!

Love it and thanks for sharing!!

@@mjhardee love it and I've done that same process before as well!

Hi Pawan! Thank you for sharing this compliment! You can absolutely add this project to your LinkedIn and share as you see fit! I appreciate any tagging and thank you for sharing! I hope this will help you land a job!!!

Thanks for your question! I utilized various google icon searches and found a site that allowed free icons. I’m not sure which specific site I used but hope this helps!

Thank you for sharing and I’m happy to hear you think the video is helpful and detailed! What a great question, 32 levels is huge! Offhand I’m not able to recall a method to dynamically create levels but I wouldn’t be surprised if one exists. I would probably go brute force and just manually build out a hierarchy 50+ levels to account for future growth and then be set. Thanks for our support and please share with others!

Thanks for your question, first step is to decide what you want instead. If blank, you can change the Dax around so the thresholds return nothing

Great question and thank you for asking. I’ll make a note to look into this

Wow thank you so much!!! I am incredibly thankful for your kind compliment and support!!!

Thank you so much for sharing this and I am thankful for your support!!!

Your encouragement just made my day! Thank you for all of your support and I’m so happy to hear you think it’s awesome!!!

Thanks for your question! A role type of hierarchy (employee/manager/director/etc…) would have to be treated differently. In your example, taking the roles out, the manager is a direct report to CEO technically. The entire PATH function system is based on child/parent IDs, so you’d need to create your own new data set which has the manager linking to a blank director who then links to CEO. It’s all about the parent/child links in your dataset :)

Thanks for sharing and totally agree! Here’s a helpful article on branching strategies. tilburgsciencehub.com/topics/automation/version-control/advanced-git/git-branching-strategies/

Thank you for sharing and it’s awesome how you found it useful!!!

Appreciate you for sharing your thoughts!

Glad it’s useful and thank you for sharing!!!!

Wow your comment just made my day! Thank you so much for sharing these encouraging words and I am thankful for your support!!!

My pleasure and thank you for sharing!!!

Thank you for sharing and I’m happy to hear you found the video both useful and knowledgable!!!

Thank you for sharing this compliment!!! I’m so happy to hear you found the video insightful!!!

My pleasure! Glad you like it and thank you for sharing!

So happy to hear you like it! Love the metaphor and thank you for your support!!!

Thank you for sharing!!! So glad you like it!

Thank you for sharing!!!

I’m glad you think it’s amazing! Yes, if you go to the GitHub URL used in my other videos, there is a file “Mastering the scatterplot”. That file should contain what you’re looking for.

@@PowerBIBro Okay Sir Thank You 🙏 so much

Love that idea!! Totally agree that is a great use case!

Thank you for sharing and great catch!!! I've updated the git repo to include links to the files as well and I've updated the video description to include the links. You'll want to download these then repoint the source of both connections to the files you've downloaded Please let me know if this helps!

** DOWNLOAD DATSET FILES ** PBI - 20240726 - campaign_data.csv github.com/powerbibro/powerbibro/blob/main/PBI%20-%2020240726%20-%20campaign_data.csv PBI - 20240726 - nearest-earth-objects(1910-2024).csv github.com/powerbibro/powerbibro/blob/main/PBI%20-%2020240726%20-%20nearest-earth-objects(1910-2024).csv

Glad it was helpful!

My pleasure! Thank you for sharing and I’m glad the video is helpful!!!

Thanks for this question, glad you reached out! The funnel chart definitely works like other charts...eg. click a section of the funnel chart and it will act as a filter. Make sure these two items below are setup, you may just be experiencing a side-effect of another issue. If you open the file in the repo which I use for this demo then make these updates it should function as you expect, let me know if this helps! 1. edit the model relationship, change the link between [Stage Stage] to have 'BOTH' as the setting for Cross-filter direction, it's currently 'Single. 2. open up the options, go to report settings, edit default interactions to be cross filtering instead of cross highlighting. Hopefully this demo's the intended functionality!

@@PowerBIBro Thx for aswering, Just saw your pbix file, but the problem remains: Considerating Lead if the first stage of your funnel chart well, you don't have 268 Lead (passed by) the lead stage right? Here we see a diference in the funnel chart logics. If you have a universe of 478 register and your first step of the pipeline is "lead", my funnel chart will display 478 leads (passed by) at the first step, and yours, 268 leads (stopped at). So if you would follow this "pipeline" logic, what would you recommend to use the funnel chart to filter the other visuals?

Love the question and thank you for reaching out! For this process, you'll need to proactively build out empty layers for future growth. To my knowledge there isn't a dynamic way to do this using the methods via PATH functions creating columns. Let me know if you find something different!

Spot on correct! Thanks for sharing, the DAX query updates are great!!!

My please glad you love the video!!!