Is it possible to visualize the changes inside the dashboard? I made some changes to a file and my friend did other changes, now i need to merge, keeping both changes
@PowerBIBroКүн бұрын
Yes it is possible and thanks for reaching out. In order to merge changes, you’ll need to look into a tool like the ALM toolkit. Here’s some documentation around it. It will detect all changes and you can then choose which changes to merge. powerbi.microsoft.com/en-us/blog/announcing-tmdl-support-for-the-alm-toolkit/
@yomnaali4530Күн бұрын
thanks for this, it sorted half of my problem, but there is a slight error that actually shows in your video as well in minute 33:12. if you add up the headcount under Juwihu it equals 57 not 58 and the same with the sales the number is less. the same in minute 39:55 under Cykaja, it is still including the manager in the total number. I have the same issue in my data set as well. did you figure out a resolution for this?
@DIGITAL_COOKING2 күн бұрын
nice one keep doing! :)
@PowerBIBro2 күн бұрын
Thank you for your support and I’m happy to hear you like it!!
@praveenarumugam85162 күн бұрын
Thanks for Sharing . Very Useful
@diya_dr56 күн бұрын
27:00
@PowerBIBro3 күн бұрын
Haha! Thank you for your support!!
@ZBillions236 күн бұрын
This is a great instructional video for source control. I appreciate the information you shared as we're moving to Power BI and looking to add source control. I have a question that's not related to source control but instead about editing the .pbip in the Visual Code. Say I wanted to make edits in the Visual Studio Code IDE instead of Power BI, I assume the user can do that right and check in the changes all within the IDE? We're switching to Power BI from another vendor, and with our previous vendor, it's super simple to change the facts and measures and where clauses in the code. How can a user do that within Power BI? Thank you
@PowerBIBro3 күн бұрын
Thank you for this compliment and I am happy to hear you love the video!! You are 100% correct! With the new pbip files, you can edit them directly in the IDE if desired (typically VS Code), then check in the changes. I’ve found that it’s still easier to create the code in PBI itself, but if you need to ‘copy’ code, the above method is perfect. Here’s a link to more information on the pbip files themselves if it helps, thank ms for your support!! learn.microsoft.com/en-us/power-bi/developer/projects/projects-overview
@christophmeirich59287 күн бұрын
Thx for sharing :-) How do you calculate longitude and latitude? Thx in advance!!!!! Greetings from Germany Christoph🙂
@PowerBIBro3 күн бұрын
Thanks for your support and your question? To confirm, are you wanting to visualize long and lat or are you trying to calculate the values? The values ‘coordinates’ themselves need to provided to PBI as a source vs calculate them. If your needing some additional help with visualizing them, the below web link may help! learn.microsoft.com/en-us/power-bi/visuals/power-bi-map-tips-and-tricks
@Zoubfvgus11 күн бұрын
Hey❤ thanks for this amazing project, I am a aspiring Bi developer was wondering can I use this project in my portfolio?
@PowerBIBro10 күн бұрын
For sure! Thanks for your support and I’m excited for your Power BI future!
@haider543011 күн бұрын
Do you have a playlist suited for someone who wants to learn power bi from beginning to end to the very advanced levels?
@PowerBIBro10 күн бұрын
Thanks for sharing and I’m happy to hear you like the videos! Currently for an end to end project which contains some advanced stuff, check out this 2 hr tutorial! Power BI Project END TO END: Full Development Course!!! kzbin.info/www/bejne/f5-8qahonZyibKs
@urlyricsv991512 күн бұрын
Thank you bro for sharing please don't stop ! your tutorials are very interesting.
@PowerBIBro10 күн бұрын
My pleasure and thank you for sharing this compliment!!
@Alexanderr-n8e13 күн бұрын
Hi Power BI Bro, I was looking to create a heat map with the Map Visual but in the visual settings there isn't a heat map button, should i enable anything to obtain it?
@PowerBIBro10 күн бұрын
Excellent question and thank you for reaching out!! A heat map is certainly possible, but it will only work on the Azure Map. If you check out the below article it should provide some additional details. learn.microsoft.com/en-us/azure/azure-maps/power-bi-visual-add-heat-map-layer
@carlosgarciamartinez338013 күн бұрын
Question: I need to create this same card, but for YTD (Year-to-Date), I have three variables: Total Crime, Total Solved Crimes, and Total Arrests. If I select a year, for example, 2023, I would like to see the three variables up to a day like today but from 2023, followed by the same data but up to today from 2022, and then the variance. I’ve tried various ways to do it, but so far, I haven’t found the right DAX formula. Could you provide some reference or help with this?
@PowerBIBro10 күн бұрын
Thanks for your question and I’m happy to hear you found the video helpful!! At a high level, it sounds like you need to create two separate measures. A YTD for current year, then a YTD for previous year. If you check out this documentation it will help with YTD foundational DAX. Let me know how it goes after you give this a shot! learn.microsoft.com/en-us/dax/totalytd-function-dax
@suyashlade2513 күн бұрын
for waterfall model, i followed all your steps but i am getting same that is blue color for all,why so?
@PowerBIBro10 күн бұрын
Excellent question! This small step was missed in the video, if you check out some of the other comments you’ll find details around how to solve. At a high-level, if you go to your model and update the filtering to be bi directional it should fix the issue. There are also other workarounds if that doesn’t fix it! Thanks for your support and sharing your question!
@carloscantu7514 күн бұрын
Thanks for sharing, that was a really good and detailed explanation.
@PowerBIBro14 күн бұрын
Glad it was helpful and thank you for sharing!!!
@AnandKumar-jq8mj15 күн бұрын
Hi, This was a great video. Very helpful. I'm trying to use this logic for creating a hierarchy for ADO workitems. Can we integrate string columns like Title, State of workitems into this matrix visual?
@PowerBIBro14 күн бұрын
Love this question and leveraging this method for reporting ADO work items is completely possible. I have created multiple data models utilizing this process to create hierarchies for Epics/Features/Stories/Tasks etc.. you can leverage this same methodology and return items like title/state etc. I'll need to research a method to return these files in the same matrix visual though, I'll look into it! If you come up with something please do share!
@AnandKumar-jq8mj14 күн бұрын
Thanks for the quick response. I'm trying it out. Will share what I come up with.
@mnedix15 күн бұрын
HI, I was looking for something like this for quite some time and I finally found it as a complete guide, thank you for your work. Quick question/mini-scenario: - I configured two measures to work with the hierarchy - count of people and sales (like in your example) - I "bucketed" the Sales into Min, Med, Max (based on a arbitrary value) - a simple Switch statement - if I display a matrix with Hierarchy and Sales then whenever I select a bucket then the hierarchy nicely displays only the people in the bucket (not showing the other people) - if, to the above case, I add the count then the hierarchy will the selected bucket value but also empty rows. This makes sense since the count measure is also in that matrix and it does have a value - is there any way to "make" the Sales measure take precedence?
@PowerBIBro14 күн бұрын
What a great question and thank you for your support! My first thought is to understand more about the switch statement which buckets the values, is this a measure or calculated column? I would suggest doing an experiment where this is converted to a calculated column, which is little more complex and rigid as you'll need to write DAX which predetermines the granularity for which the sales are bucketed (week, month, year etc..). But then, as that is now a column within the data, I'd be curious to hear how that impacts your end results.
@mnedix13 күн бұрын
@@PowerBIBro The bucket can be anything that makes sense in the data context. For example, Sales under 10.000 USD are Min, Sales over 20.000 Max and Med is in the middle. A simple formula could be: Sales range = SWITCH(TRUE(),[Sales]<10000, "Min",[Sales]>20000,"Max","Med") Any other measure would basically do like region, performance, count of Orders etc. I hope it makes sense.
@desenterrados202216 күн бұрын
Hi! Does a Premium Per User License does the work? I don´t think so! So... The Premium User License is a very expensive one... Is there a workaround for this? Thanks a lot!
@PowerBIBro14 күн бұрын
Excellent question and thanks for reaching out! A PPU license will unfortunately not work, the below article from MSFT is helpful for detailing the requirements. "... You need to have write access to a workspace that is on F64 or Power BI Premium in the Power BI service". So ultimately, for copilot you need to running on F64 or Premium capacity. learn.microsoft.com/en-us/power-bi/create-reports/copilot-introduction
@desenterrados202214 күн бұрын
@@PowerBIBro ok, thanks a lot, Rob!
@RobertoStaltari18 күн бұрын
Every time there's a new Power BI release, *everyone* rushes to post videos about the latest features, but the videos from Power BI Pro are out of this world! And let's not forget the cherry on top: they even provide a PBIX file so you can dive in and see it all firsthand. It doesn't get easier than that! Power BI Pro is, without a doubt, the number one, hands down!
@PowerBIBro18 күн бұрын
Wow!! This is the greatest comment and I am so thankful for you taking the time to write it and share it!! Thank you for your support and I am so thankful for being your number one!!!
@dcbelbiteam14 күн бұрын
I agree wholeheartedly!
@josephansah18 күн бұрын
You're a time saver. Much appreciates & thank you 🙏
@PowerBIBro18 күн бұрын
Thank you for sharing!!! I’m happy to hear you like the video!
@mrbartuss118 күн бұрын
Is it available in Pro licence?
@PowerBIBro18 күн бұрын
Great question and thanks for asking! I think you need a premium license and there are a few options. Below provides a summary of the different license types. learn.microsoft.com/en-us/power-bi/fundamentals/service-features-license-type
@noahbehrick74319 күн бұрын
Really good video. Excited to dive into the Fabric Metrics Layer myself
@PowerBIBro19 күн бұрын
Thank you so much and glad you like it! I’m excited to dive into it as well!
@HappywithCath19 күн бұрын
Amazing! Always so helpful!
@PowerBIBro19 күн бұрын
Thank you and I am happy to hear you think the video is amazing!
@MartaTodorović-m3v22 күн бұрын
Thanks so much for the video, very informative and helpful! Very thorough, just the way I like it :D
@PowerBIBro21 күн бұрын
Thank you so very much and I am happy to hear you found the video helpful!! Thanks for your support and for sharing!
@gezin_longuevilleosaer424522 күн бұрын
Great video, thanks
@PowerBIBro22 күн бұрын
Glad you liked it and thank you for sharing!!!
@cherylwang942822 күн бұрын
Thanks for the video! Have you considered showing the steps in a blank power BI workbook with just the raw data instead of on top of the finished one? I personally think it will make things even clearer.
@PowerBIBro22 күн бұрын
Glad you liked it! That is a great idea and I will take it into consideration for future videos. Thank you for your support and for sharing!!!
@maitrph23 күн бұрын
Hello Robert, I've finished all the parts except for the Azure map. Couldn't enable Azure map in PBI Desktop - free version whereas other maps work fine. The notification was: "To display Azure maps visuals, sign in". It requires a work or school account to sign in which I don't have (only have a personal one). Not sure if creating a free Microsoft Fabric account would fix the issue. Do you know the solution for it or perhaps the only way to fix it is by upgrading to a paid account? Much appreciated.
@PowerBIBro22 күн бұрын
Excited that you've completed the majority of the video and thank you for sharing! Great point about the Azure map and the sign-in step. If you do not have a work account there most likely is not a way around this to my knowledge. Please let me if you find a route to resolve it!
@victoraguirre748623 күн бұрын
Question. How does the data get grouped in descending order? Is it just grouped by quantity of individuals per category? Say we have 3 categories 1, 2 and 3. How does it know the order of “cascading” individuals per category?
@PowerBIBro22 күн бұрын
Thanks for your support and for this question! Offhand, if I am understanding your question correctly, I believe the answer is that it is grouped by quantity of individuals per category. By default, in then sorts these buckets into ascending order, you can click the [...] in the upper right to change to sort in descending order. Hope this helps, please let me know if this answers your question!
@victoraguirre748621 күн бұрын
It does yes! I was wondering about if there was a reason to show a certain order, rather than having them show up grouped by quantity
@PowerBIBro21 күн бұрын
Gotcha, yes that can certainly be a reason! It's possible to sort by category instead of quantity, so if there is a logical order you'd like to sort the bars in, you can do that as well instead of the quantity. Simply choose to sort by category and you're all set!
@sandrilakingdom910626 күн бұрын
Wow... thanks alot
@PowerBIBro26 күн бұрын
My pleasure and thank you for sharing!!!
@kasilvania28 күн бұрын
Is there a way to have the level 01-08 pull multiple variables like name AND title so they both show up in the decomposition tree?
@PowerBIBro28 күн бұрын
Love this question! Thank you for asking it and I appreciate your support! Yes, offhand this definitely seems possible and it will require some more advanced DAX manipulation. Essentially, if the goal is to return Name and Title in the same value, I would evolve the path functions to return both of these values independently, then concatenate them together as the result in what is being returned. I hope this helps point you in the correct direction, please let me know how you end up solving this one!
@Deepjoshi198629 күн бұрын
Amazing video, this is the exactly what i am looking for. Thankyou so much for the video and the way you explain is awesome 😊 Jut need 1 help how to handle if child is mapped to skip level directly Example: level 3 directly reporting to level 1
@PowerBIBro28 күн бұрын
So happy to hear this is exactly what you are looking for! Appreciate your support and thank you for sharing! Here's my thoughts on your question. If a level 3 has a level 1 set as the parent then technically it is actually a level 2, so we'll need to update the data to force a break/space. It will require data manipulation, but to solve this, I would create a dummy record called 'level 2 empty' and have this roll up to the level 1, then I would change the level 2s (who need to be level threes) to be the child of this new dummy level 2 record. This should create the gap. I hope this helps, please let me know how you end up solving this one!!
@analytic_panda29 күн бұрын
a comprehensive lecture, but given my experience teaching this stuff in a college, I suggest you go much slower for beginners...
@PowerBIBro28 күн бұрын
I really appreciate this feedback and thank you for sharing! I am thankful for your support and will take this advice into consideration with future videos I create!
@hafizasim4245Ай бұрын
where is the total of all
@PowerBIBro28 күн бұрын
Excellent question and thank you for asking it! Unfortunately, to my knowledge by default there is not an option to add a total value, however it is possible via a work around! You can create a KPI card which calcs the total and overlay it on the funnel chart. Here's an article describing this approach. Hope this helps and thanks for your question! community.fabric.microsoft.com/t5/Power-Query/Add-Total-Row-to-Funnel-Chart/m-p/857002#M28810
@hafizasim424528 күн бұрын
A better solution might be to union two tables which add a total I read this solution over bi community and achieved the same
@pallamgouthamkumar199Ай бұрын
When we publish reports in service where all the reports will store is any particular storage in cloud
@PowerBIBro28 күн бұрын
Thanks for your question! To my knowledge, the backend service configuration will depend upon how your Power BI Service is configured. However, much of this taken care by MSFT as PBI Service is SaaS. You can dive into various PBI Service articles starting with the link below, hope this helps! learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-service-overview
@adamtoth7544Ай бұрын
Thanks for the video! Is there a way to change the bins so that the last bin contains everything not contained in the other bins?
@PowerBIBroАй бұрын
Thanks for this question! It is possible to create custom/dynamic binning, however the visual itself doesn't do this. To solve for this, you can create custom dax to bin the results, then the pie chart can visualize them. Here's an example article on binning. There is more than one way to do this though, but overall you'll want to bin in the data model then visualize the results in pie chart. community.fabric.microsoft.com/t5/Desktop/Binning-of-count-data-for-pie-chart/m-p/1311908#M569214
@madhan.mtammi4178Ай бұрын
Bro ... On the Calculation table you just showed how to create some measure like title, votes and AVG but when you started creating visuals I could see Movie , TV and Formating Folder under Calculations where are these come from you not shown how to create it :(
@PowerBIBroАй бұрын
Thanks for this question! You're totally correct, there are other measures and dimensions created which I did not detail in this video. I wanted this video to focus on using data vs prepping it. If you go to the transform layer (power query) you can view the multiple data cleansing steps I performed.
@PowerBIBroАй бұрын
If you have a specific field you're interested in, I'll be happy to give a summary about it
@Ananthi6851Ай бұрын
Is there any way we can monitor the subscription, such as how many emails were sent on a particular day?
@PowerBIBroАй бұрын
Excellent question and thank you for reaching out! Offhand, I've solved this problem in the past by creating my own solution which pulls all of the activity events from the Power BI Service. You can then analyze these events at a very detailed level, including deducing subscription fires. It requires some custom admin dev, here's a high level article. learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events
@Ananthi6851Ай бұрын
@@PowerBIBro Thank you for the guidance
@mileruiz1Ай бұрын
Thanks
@PowerBIBroАй бұрын
My pleasure and thank you for commenting!!!
@pallamgouthamkumar199Ай бұрын
Hai bro I wasn't find Drill-through option in New verson of Powerbi
@PowerBIBroАй бұрын
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
@pallamgouthamkumar199Ай бұрын
Thank you bro I am subscribing you now good explanation
@PowerBIBroАй бұрын
Dude thank you for your support!!
@ExactitudeITАй бұрын
Hi Power BI Bro, Thank you very much for this great video. I actually got really far with my solution using your video. Thank you! I do have an issue with the blanks when I am using xViz Performance flow visual in Power BI. I am using it to create an organization hierarchy. It is such that if the lower level of the hierarchy has no value than the upper level will not get shown either. I.e. the highest level CLT has OPR and CIT as immediate child nodes. CIT has no further children. So when the hierarchy is extended till level 2 you do see CIT and OPR. But if the hierarchy is extended to 3, you only see OPR. I would like to keep seeing OPR. I do have an excel file with the structure and all the calculated columns done. If you kindly reply then I can showcase it. Thank you for your knowledge sharing! Best Regards Exactitude (Rehman)
@PowerBIBroАй бұрын
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.
@ExactitudeITАй бұрын
@@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?
@PowerBIBroАй бұрын
@wajiharehman9011 that’ll be great!
@ThomasdegaardАй бұрын
Really nice video! I tried to do something similar with my own semantic model, however for some reason I cannot get the images to appear in the new slicer button. When I put the column with the reference url into a table, the link works fine. I have tried to set the data category in the column with the url's to Uncategorized, Web url and image url, but it still does not appear in the new slicer button. My images are placed in a one drive folder. Do you know what can be wrong?
@PowerBIBroАй бұрын
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
@ThomasdegaardАй бұрын
@@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(?)
@felixvalembois9596Ай бұрын
Thank you for the tutorial however I have a question, Each time i hit the '+' button all my information just slides into the deepest level of my hierarchy and i have no information on my row, i tried multiple things but nothing worked so far. (some information just in case : I'm working on a database already flattened, hierarchy has been built thanks to column names, I foud a way to re-create the 2 mesures of depth like in the video and hide the blanks.)
@PowerBIBroАй бұрын
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
@sebastiangarcia60Ай бұрын
Thanks man! Super cool tutorial
@PowerBIBroАй бұрын
Thank you so much!!
@10xApeАй бұрын
Is there any data limit to this visual ? It doesn't work with a bigger data
@PowerBIBroАй бұрын
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
@tonymiller225Ай бұрын
Best Decomposition tree on KZbin - nice one dude
@PowerBIBroАй бұрын
Thank you for sharing and I’m happy to hear this feedback!!!
@ifoodieTVАй бұрын
1 thing. I can't find or figure out. Where is OPEN REPORT. It is suppose to open a file from your desktop. Only thing I can find is FILE. Then OPEN. Which OPENS the recent files in POWER BI not OPEN REPORT. I guess that I can ask COPILOT. Unless you have any advice? I have a screenshot of it showing. But it is a few years ago. Microsoft updates POWER BI all the time 😢
@PowerBIBroАй бұрын
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
@alexyoung3436Ай бұрын
Jesus Christ, where can I find vertical waterfall chart without scam & $100000000 dollars to pay per user?
@HappywithCathАй бұрын
This is really helpful per usual!
@PowerBIBroАй бұрын
Thank you for sharing!!!
@sistercynthiaatgmailАй бұрын
Say I've got salespeople who have multiple clients. Can I have it filter the page by each client they have and send it to that salesperson? This would be in lieu of a paginated report build. I've got the data needed but just not sure if it's possible. It would turn a 1 page dashboard into an 8 page PDF if they have 8 clients, if this can work the way I'm imagining.
@PowerBIBroАй бұрын
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!!
@onelangelsanchez9003Ай бұрын
Can I make it work using zip codes?
@PowerBIBroАй бұрын
Most certainly! To use zip codes in maps, you’ll want to set the data type of the zip code to geographical