วีดีโอ

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!!!

Thank you for the compliment and thank you for these questions! I'm happy to hear that you found the video helpful. Both your questions are great, and both are potentially complicated :) Offhand, I'll need to do some research into how to pull the desired results for both examples, but I love both use cases. In the meantime, please let me know if you find a solution!

Thanks for sharing this question! To help confirm your ask, are you stating that parents without children are not showing up? If so, that should not be happening. As an example, in the file provided, go to the tab [Hierarchy] and see the person 'Qa Dibivo' under 'Fufe Be', this person has no children but is showing up. Hopefully this helps, if I'm missing the question please let me know and I'll be happy to help!

Your feedback is spot on and thank you for sharing it. In my next video I am going to focus on ensuring my voice is louder. :)

Thank you for sharing and I'm happy to hear the video helped you build something similar! For your question, can you provide a little bit more detail to help with troubleshooting? Specifically, what are you referring to pertaining to "value option"? If you traverse the visual's formatting menu, which specific field. Example.. [Callout values] -> [Values] -> [Show blank as]. With this additional detail I'll be happy to look into it and see how I can help!

Awesome!! So happy the hear that the video was helpful!!!

Love to hear that!!! Parameters are great and I'm happy to hear you found this video helpful!

Love this question and thank you for sharing! There is a way to solve this, check out the latest video I just posted (link below). The July 2024 update included a Reference Layer update associated with Azure Maps. Essentially what you'll need to do is create a geojson or kml file which contains the boundaries of your territories. In the video below you can see that I do this same thing for Chicago neighborhoods. th-cam.com/video/hI-TdZiRke0/w-d-xo.html

Thank you for sharing and I appreciate the compliment!

Thanks for sharing your question! To help with troubleshooting, if you click on the table created by the new parameter, does it list all values within the range (up to 100) or does stop at 99. Also, please share the DAX code for the table above for reference, example below for code within the project. What If Returned % = GENERATESERIES(CURRENCY(0), CURRENCY(1), CURRENCY(0.01))

Wow I love this and thank you so much for sharing!!! I am so happy to hear the video cleared up questions and resolved your current need!!!

Thank you for sharing and I appreciate your feedback!

Thank you for sharing and happy to hear that you think it's nice! The datasets are provided by Microsoft via their sample datasets URL below, please check it out! This specific one is based off of the 'Sales & Returns' dataset. learn.microsoft.com/en-us/power-bi/create-reports/sample-datasets

@@PowerBIBro Thanks for your kind support 🙏

Glad the video was really helpful and thank you for sharing!

Glad you think the content is excellent! Thank you for sharing and for your support!!!

I’m happy to hear you think the video is ex excellent!! Thank you for sharing and for your support!!!

Thank you for the compliment and I’m happy to hear you think the video is great!!

Thank you for sharing how you like the explanation! Happy to hear you use them all the time and thanks for your support!!

Glad to hear you like the video and thank you for sharing!!! Creating a video on layouts and background design is an excellent idea and I will add it to my list!!! Thank you for your support!

Hi and thank you for sharing!!! I am so glad to hear that this video was helpful!!!

Happy to hear your think this video is great and thanks for sharing!!!

Thank you for sharing and my pleasure!!!

@@PowerBIBro can you upload more project like this it will be really helpful for us

@noxious8507 absolutely, on my list to create another full length project! Thank you for your support!!!

Thanks for sharing!!!

Hi and thanks for your question! You are correct that you should avoid many to many relationships. To help, if you download the file from GitHub do you get the same issues?

I cleared it thanks for the reply ❤❤❤ expecting many impressive project like this to attract the recruiters🎉

Thank you so much for sharing and I am so happy to hear that you love it!!!!

Thanks for sharing how you enjoyed this video!! Great question, for the concept of this video, the clickable cards will function by filtering on field only but there is a way to filter on a measure value outside of this presented concept. It would be to utilize the filter pane on the visual using a filter for the measure applied to the visual. This is because measures are calculated by whichever filter context is applied, so they cannot be utilized the same way categorical values are.

So happy to hear that you are looking forward to learning more and thank you for this comment!!! Yes I definitely have a video pertaining to organization charts, check this out below! Mastering Power BI PARENT CHILD Hierarchy: A Complete Guide!!! th-cam.com/video/iwRqSl-_zvU/w-d-xo.html

Love this question and thank you for asking it. Filtering on date range is possible more a bit more complicated and a few additional steps need to occur. For this example, I'll assume you want to create a relative filter, e.g., "records last month or last year or yesterday" etc... To have this work in a dynamic subscription, you'll need to add a new calculated column to your data model which returns text in a column aligned to the desired relative date. Example... if we wanted the subscription to send records for "Yesterday", in the data model, create a Boolean calculated column which returns True if the date is yesterday, then filter the dynamic subscription for "True" on this new field. Hope this helps!!!

Awesome input and thank you for sharing!!!!

Hey thanks for sharing your thoughts! A link to Microsoft’s June 2024 blog post is below. This video follows it, TDML has been in preview for a long time, but PBIR delivered within PBIB files is new. Everything I cover aligns with their June 2024 release notes. June 2024 Release Notes powerbi.microsoft.com/en-us/blog/power-bi-june-2024-feature-summary/#post-27479-_Toc168491987

Thank you so much for sharing and I’m happy to hear you think this is the best video!!! Appreciate your support!!!

Love the question and thank you for asking it! You can apply the gradient option from format style but you'll notice an important difference in the color results. To test it out, apply the gradient option and use the value of # Titles. You'll see the gradient does apply, but it scales from highest 'VALUE' to lowest 'VALUE', so the color does not go from Top to Bottom like the applied levels. The scaling would function similarly to how the bar chart scales from high to low. Hope this helps clarify the difference!

Glad you think the videos are awesome! This comment just made my day, thank you for sharing!!!

Thanks for sharing and I appreciate your comment!

Love it!!!!

Thank you for asking this question and I'm happy to hear you enjoyed the video! This solution is designed for one specific direction. If you wanted to setup a 2 direction what-if solution I'd look into the following steps. It's a fairly complex solution but this is what I would attempt to complete. 1. Create a what-if scenario following the video 2. Create a second what-if scenario going to the inverse direction, updating the DAX where applicable 3. Create a button which toggles these visuals to show/hide 4. Stack the visuals on top of each other 5. Use the button to determine the visibility of each what-if scenario. It's a fairly complex solution but this is my first iterative idea, let me know what you decide to go with!

Thank you for sharing and I’m so happy to hear that this is the best feature update video you have seen!!!

My pleasure!!!

Thank you for sharing! I’m happy to hear the content helped and you think it is amazing!!!

Thanks for reaching out and I'm glad the video is helpful! To confirm, are you wanting the end user to be able to select from different measures and them flow into your map... examples, maybe sales, profit, and units - you'd like the user to pick one of these. If so, the answer is to create a field parameter. Here's some documentation from Microsoft. I don't have a specific video on this but I do create them in my scatterplot video. If you watch that, you'll see how to create field parameters, then you can apply these to a map. Microsoft. learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters Power BI Bro - Scatterplots... there is a chapter on field parameters. th-cam.com/video/I4ewYX04D4c/w-d-xo.html

Thank you for your question! I can certainly provide info on the dataset utilized. For this maps video, I used Kaggle's Billionaires Statistics Dataset (2023). You'll see the power query in the PBI file has a series of transformative steps, but the raw data can be found below! Enjoy! www.kaggle.com/datasets/nelgiriyewithana/billionaires-statistics-dataset

Definability!!! I agree and thank you for sharing!!!

Even PBIR has been there on preview for ages. This was all click bait

Very happy to hear you enjoyed it and thanks for sharing!!!!

Ha!! Thanks for sharing and glad you found it interesting!!!

Thank you so much for sharing this compliment!!