You guys are great. I'd love to see more stuff like this where it takes the simplicity of the program to the next level! Thank you for keeping things interesting, too. My wife looked over my shoulder once and commented on how well you made such *ahem* mundane stuff watchable.
I knew 4/5, nice video though! For me the must knows are the quick access toolbar, using search for format fields, the “horizontal slicer”, extract precious in query editor and image charts (table with data bars)
I’m new to Power BI, so all of this was new to me. Looking forward to learning more & applying that knowledge! I just subscribed. Thanks for the training!
Thanks Patrick! I knew 2 through 5. With Query Grouping becoming a staple in all datasets created, just to keep it clean and focused. Looking forward to the Custom KPI Card video!
Thank you Patric,. for me all 5 were new and awesome. I use the table for storing all measures. As for the pivot - matrix. I think it will be a matter of time that you can adjust the structure of the matrix in some predefined formats, just like in Excel.
I am getting better. this is the first time that I know all the tips. For Create a table from Scratch I prefer to use the function Table.FromRecords and pass a list of records containing my data.
I am working on Power BI from quite some time, but these tips/tricks were amazing. Thanks for sharing this video and all other super-amazing stuff at GuyInaCube.
Good stuffs! There are so many similar small but useful features I found out out of curiosity, out of frustration, accidentally by mis hitting keys and been using those features since then :D
Hi there. Mr GuyInACube, did you know that you can select multiple objects in PQ without clicking each of them with CTRL? Just click the first one, hold SHIFT and click the last one. All intermediate items will be included as well.
Hey Patrick, you have made me a BIG fan of you and the unique style of presentation made it more interesting to watch! Thanks friend! By any chance you happen to come to India and especially to Bangalore? Do keep me informed if there is a visit, I would love to be your host here!
Hi Patrick you and Adam always produce great content ... congrats! Would be possible to show us how we can use the "traffic light" (green, orange, red) depending on a selection? I want to build a status report where I need to report each one of my 4 categories "Overall", "Schedule", "Cost" and "Resource" using the traffic lines. They are not related to number like your example. Thanks
Hey Patrick, for countries i use the recommended three-letter abbreviation, but i just found out that the geocoding result depends on the Power BI Desktop application language. Maybe you could ask the Bing Maps Team, why the culture de-de doesn't detect the ISO 3166-3 country letter "RUS".
Can you demonstrate how to code DAX in power query editor with a table with a column of timestamps and needing to create a duration by subtracting one value from another in the same column, not always able to use an index. Thanks
Hi Patrick. Just starting out with Power BI and I don't see how to filter by a dynamic date like Today or Now. I did find out how to build out a custom date filter but with that you have to actually specify a static date or date range. Got any advice/hacks for this? Thanks!
Hi Patrick, thanks for sharings your knowledge with us. Something I would like to know from so long... Is there a way to move quickly inside a big table in power BI? You know shortcuts like Ctr+end.
"everything in Wikipedia is true" ... Wikipedia is going to use this video as reference :P "Microsoft Certified Data of being TRUE" :'D. As always thanks for the awesome video! I love the way sometimes the content is more technical while sometimes the content speaks to the wider audience! Love it and wish i could double subscribe :D
pivot on matrix is game changer for me. was struggling to do that since long finally your video help me . Cheers !!!. One Question. If Matrix/ table has data which is 10 page long, how can you print all 10 pages at once (even pdf would be okay). i can only print current page at a time. appreciate your response
Guy in a Cube Your videos are excellent Patrick. Really enjoy watching them and I learn a lot. Thankyou. Same with your friend’s videos. Excellent team.
4.5 out of 5 for me but I hate not knowing so, the first one (selection box on custom KPI card) I knew about selection box but I don't know how to make a custom KPI. Do that video please.
Hi Patrick, Thanks for this great video. I need a small help. I don't have the properties filed under the modelling in order to set the map settings. could you please tell me how can I activate it? Thank
Hello, I have been stuck with this problem for days... I was tasked with looking at how clients changed groups in a 5 year period. I have made 3 groups: low spending, intermediate spending and high spending. I have client numbers for each one of them and my goal is to see how they move between the groups between a 5 year period. For example in 2014 to 2015 how many people moved from low spending to intermediate, high or stayed the same. I would really appreciate your help with this! Thank you so much in advance!
Patrick - I got excited for a minute there that you had solved one of my issues! Unfortunately no. I have a multi-row card that is auto formatted to 2 decimal points. Which I don’t need. And I don’t have access to the data model as the data is coming from AAS that I don’t have access to. I can’t find a way in the Desktop to format the card to 0 decimal points. Can you help?? Many thanks Mark (maybe your answer to the comment below will also cover multi-row cards??)
Hi Patrick I'm following your channel you're awesome and thanks for share knowledge with us. I'm tableau developer I started learning n creating reports in power bi so I want to try weekly challenges is there any Power BI weekly challenges web portal like ’tableau work out Wednesday site’ Please, tell me Thanks, advance
Hi Patrick. No doubt you are doing a great job. Any suggestions on how you formatted the pie chart with red and green, I cant see the conditional formatting option in the data colurs. Assuming you created a new custom theme?
Number 5, you mentioned about 'Group', can you please describe a 'Use case' of that grouping? Under what circumstances, we do 'Group' and why? Thanks in advance.
As I understand it, grouping is the equivalent of organizing documents into folders. Once you have a big long list of queries (documents), you would want to be able to navigate that list more quickly, by putting the queries (documents) into folders. What folders you would have would of course depend on the data you have and how it makes sense to YOU to organize it.
Hi, for the map tip, in the fields section was the "world" icon already coming next to the data. I've worked with location data before but this never happened
Well, I don't understand the reasoning to use the selection pane for editing the visual when 99% of visuals/graphs can be edited via the normal paint icon. Please microsoft normalise that.. Thank you for tips,.
Hi Patrick, I have noticed that the left new filter Pane is not following the report page scaling, it is too small and not visible, eventhough I have increased to the max the width and text size of the filter pane, (BTW it was perfect before March update, and still after April update) Please help
Is it possible to dynamically change field title in a Matrix. Like if select Jan than field name shall change to Jan if i select Feb than it should be Feb else by default it should show current month. Please help.
Hey Patrick, thanks for the tips! I have a map question for you ... I was mapping out units ordered by State and the map threw PR (Puerto Rico) in South America ... do you know of a way to correct that?
Thanks a lot Patrick. Could you please make a video on how to make parameters as user input. For example when I select a year-month value in slicer it should show that month else currentmonth-1. I created a parameter and modified the M-query. Everything works fine in Desktop. When I entered a value in parameter using Edit Parameter it showed that month's data else default month. But I didn't find any option to display that parameter on report page. Could you please explain how can I achieve that using Parameters. Right now I achieved using DAX, but I want to know how to make the Parameters as user input. We are using Optimized Desktop Jan-2019 version. Thank you once again for the videos. They really helped me a lot.