My favorite DAX editor shortcuts are Alt + Shift + up/down arrow = duplicate highlighted rows Alt + up/down arrow = move the current row up/down inside the query
comment / uncomment dax code --> CTRL + ù (or CTRL+ K+C and CTRL+K+U to uncomment) code identation --> CTRL + ' (to the left) and CTRL + ì ( to the right) another one which i find useful sometimes is CTRL + P to export in PDF
Great vid Daz. #4 alternative for sorting. Divide sunflower seed sales by 100M, format with no decimals, add to table, change font to small & white, change header text to "."
I use the search feature in slicers all the time, it’s super helpful! One thing to point out though, search is only an option on columns in text format. If you don’t see the option to add search to your slicer you may need to reformat the column to text (assuming it won’t mess with any measures or calcs).
Dude... great video! The first few tips I use regularly, but the one about replacing thing with SHIFT+L blew my mind. I have some pretty complex formulas that check different cases, and that would've saved me so much time. I would literally copy the measure into Word, then do a Find and Replace, and then copy it back. One thing I've started doing for both BI and Excel is letting ChatGPT help me. I've found I can describe what I want to do, include the column/table names, and it will spit out the measure or formula that I need. If I don't like the results, I can go back to the session and, in plain English, tell it what I don't like and it will change it to match my needs. I learned this from watching another analyst's video a couple of weeks ago, and it's made my job so much easier. I still have to do all of the planning and I still attempt to do it on my own first, but it's nice having a backup who's not human, so I'm not bothering them to get an answer when I get stuck.
oohh man same here .. make sure to check out some other shortcuts as well, makes your dax life a lot easier . I'm also using it, not so much yet though for power bi development - maybe i should give it another try as it is getting better fast
@@HowtoPowerBI I'm still wary of ChatGPT and AI in general, but I can't deny how much it has helped me. Decades ago when I first learned about programming, I learned to do For...Next and If...Then loops and checks, and I've always used them. Last week, ChatGPT suggested I used the SWITCH function and redid my measure for me... it cut the measure in 1/2 and made it very readable, and it taught me how to use it. That was a huge boost to my productivity that day!
Power BI lover with years of service here! I've been watching your videos a lot this week. I have learnt so much, I feel like I have discover a new software! So excited to apply all the new tips and tricks. Can't thank you enough, your content is amazing 🤩🤩🤩
Hi You are just amazing. Just one question i have, you just again copied measures in marketing folder and CY folder is not affect data refresh or report rendering?
Awesome! I got 5 totally unknow for me on this! Thanks! Also, I would suggest, on Power Query, using right-click on any button on the ribbon and mark "Add to Quick Access Toolbar", you can easilly access using Alt button. I use it the most for Advanced Editor, Refresh Preview and Add Custom Column. View > Column quality, distribution and profile are also usefull when working with larger tables but they take a bit more space on the toolbar.
Thanks a lot for putting this video. I like the points that you mentioned in the video. One thing which is not working for me is, I want to sort legends in Time series stacked column chart using a measure in tooltip and it's not working. I tried many methods but it's not giving me desired results. It would be great if you can give some suggestions on this.Thanks !
Great video. PowerBI is becoming better and better, and your videos are a fantastic resource for learning about it. Did you know you can sort any dimension by any field*? You don't need to drag it to the tooltip*? You can also hide columns in tables to avoid seeing them.* *But only if you use Tableau 😁
Nice video as always! I like to do tooltip measure which I use in page icon for example. When choosing which page it should navigate you can just use the measure instead (as long as the name page is the same as the measure). So nice if you have multiple pages and want to change them all at once.
Actually you can call it measures, but you have to write like this [ Measures ]. The spaces are important. Btw. Love your videos. Thanks a lot for your valuable input
Hello friend, I am a close follower of yours. I would be very happy if you could explain the logic of the Dax formulas in depth. How to write meausure, what should be taken into consideration? I would be very happy if you could make a video about these. I just started this program. I hope that thanks to you, I will love it and I can prepare very good dashboards.
Great video. Although i couldn't just drag the measures to my separately created measure table. Trued using shift alt and what not. Please could you help on this
you are amazing, thank you! i have on question if i have a filter, this filter contains for example 1000 Item Name i want to search for computer the filter will show 10 computer names how can i select them after filtering? without holding CTRL and select one by one
In my experience, the folder layout gets a little funny if you try to create a Measure in a subfolder, it creates a top level folder with the subfolder name. So if you tried to create a new Measure in the Targets\CY folder it would create a new folder called CY.
Feature number 5, I can't believe that was there all along, I was so sure it didn't exist (maybe search result are skewed and only show results for old Power BI ?)
I have a Problem in Line chart Visual, I would be grateful if you answer me: In my line chart, I have 3 and more Line at the same time. I want to simultaneously see a certain value with a certain X and y on my chart. that when I do this with the Maesure, because these Line change (in fact, I select the graphs from Slicer), this is not possible, or I don't know. I can't specify this value in the Datalabels(Value and Detail) either, because It shows the values that it has selected automatically. Thank you for replying to my post
Hi dear, In Power BI the line chart I want to display a certain amount on Chart Line. I went to Data labels. A cerat a new Measure and use it in Data Labels(Detail). For example, for y = 50 and shows the value of x. I don't know why, when I do the same thing for y=10 or 80, it doesn't show it. Thank you for your help.
How to create show /hide filter pane in a page where there are already multiple bookmarks for showing different visuals. I want the filter pane to work independently without the bookmarks. Can you help me here ?
I have a calc group that contains an item that I need to change the font color of. How do you do that? So, the calc item looks at the selected measure, i.e. sales, calculates the value for the current year and the previous year, and returns the year over year change. I want it to be red if negative. Seems simple. But it is not the selected measure that I want to format, it is the calculation item result that I want to format. Is this possible?
Hallo Bas, weet jij waarom de maand (bijvoorbeeld in een slicer) altijd in het Engels wordt weergegeven, ook al heb ik alle instellingen in Power BI en op de laptop ingesteld op Netherlands?
Really useful!! thank you! Let me know if you can help me with something related with feature 4. Imagine you want to order the olympics medal ranking for all countries.. so you use a stacked bars chart with golden, silver and bronze medals.. ok... so, you can also create measures for the SUM of each one and for the total SUM of medals... Ok. but the issue is that if you pick the golden medals SUM por ordering, then the chart put China before the US since, C comes before U and they are even in golden medals... so the question is.. how to pick total medals as a second criteria of ordering? thand in advance!
datatraining.io/powerbidesigntransformation
After watching multiple videos of you, I am convinced that Microsoft is not the dad of Power BI, you are the Dad of Power BI. Respect 🙇
or the cool brother who knows all the awesome skateboard tricks
haha😂
I think Microsoft sometimes thinks "did we put that?" When he does some stuff.
Easily the best teacher in TH-cam. I spent a lot of time listening to long-winded tutorials before I stumbled into his channel. It’s great.
Multiple sort: Shift + click on column.
Brilliant! Didn't know this!
So many of these little features, happy i could show you that one ✌️
I didnt know we can multi sort. So very helpful!
Do you think column from examples is a little feature? My Entire work time is going to change from now onwards @@HowtoPowerBI
My favorite DAX editor shortcuts are
Alt + Shift + up/down arrow = duplicate highlighted rows
Alt + up/down arrow = move the current row up/down inside the query
You are the king of PowerBi. Never seen some one explain in simple, quick and smart way like you. Thanks tons!
comment / uncomment dax code --> CTRL + ù (or CTRL+ K+C and CTRL+K+U to uncomment)
code identation --> CTRL + ' (to the left) and CTRL + ì ( to the right)
another one which i find useful sometimes is CTRL + P to export in PDF
Great vid Daz. #4 alternative for sorting. Divide sunflower seed sales by 100M, format with no decimals, add to table, change font to small & white, change header text to "."
How do we like the video more than once.....jaw drop on some of the features 😱
I use the search feature in slicers all the time, it’s super helpful! One thing to point out though, search is only an option on columns in text format. If you don’t see the option to add search to your slicer you may need to reformat the column to text (assuming it won’t mess with any measures or calcs).
Double Sort using the Shift Key ... If only I knew that years ago. Your videos are brilliant.
Thanks a lot Bas. Didn't know that you can copy a query from one report to another. This will help a lot 😁👍
Awesome 🚀✌️
Dude... great video! The first few tips I use regularly, but the one about replacing thing with SHIFT+L blew my mind. I have some pretty complex formulas that check different cases, and that would've saved me so much time. I would literally copy the measure into Word, then do a Find and Replace, and then copy it back.
One thing I've started doing for both BI and Excel is letting ChatGPT help me. I've found I can describe what I want to do, include the column/table names, and it will spit out the measure or formula that I need. If I don't like the results, I can go back to the session and, in plain English, tell it what I don't like and it will change it to match my needs. I learned this from watching another analyst's video a couple of weeks ago, and it's made my job so much easier. I still have to do all of the planning and I still attempt to do it on my own first, but it's nice having a backup who's not human, so I'm not bothering them to get an answer when I get stuck.
oohh man same here .. make sure to check out some other shortcuts as well, makes your dax life a lot easier . I'm also using it, not so much yet though for power bi development - maybe i should give it another try as it is getting better fast
Same here!!
@@HowtoPowerBI I'm still wary of ChatGPT and AI in general, but I can't deny how much it has helped me. Decades ago when I first learned about programming, I learned to do For...Next and If...Then loops and checks, and I've always used them. Last week, ChatGPT suggested I used the SWITCH function and redid my measure for me... it cut the measure in 1/2 and made it very readable, and it taught me how to use it. That was a huge boost to my productivity that day!
Excellent video! On the search function is there a way to select all, like in Excel? E.g type in Emily and then "Select All" that contains Emily?
Great stuff! Wildcards and shift, no clue before
Power BI lover with years of service here! I've been watching your videos a lot this week. I have learnt so much, I feel like I have discover a new software! So excited to apply all the new tips and tricks. Can't thank you enough, your content is amazing 🤩🤩🤩
Didn't know sorting a table based on multiple columns was possible up until now!
Thanks.
Hi
You are just amazing.
Just one question i have, you just again copied measures in marketing folder and CY folder is not affect data refresh or report rendering?
I wish we had a crash course about Power BI in university
Awesome! I got 5 totally unknow for me on this! Thanks! Also, I would suggest, on Power Query, using right-click on any button on the ribbon and mark "Add to Quick Access Toolbar", you can easilly access using Alt button. I use it the most for Advanced Editor, Refresh Preview and Add Custom Column. View > Column quality, distribution and profile are also usefull when working with larger tables but they take a bit more space on the toolbar.
You save ton's of time man , you are great...................
awesome 👊😎
Hey, Awesome video as usual! what visual are you using on the first part of the video at the bottom with the time bars?
Search option is very useful; unfortunately it works only if in the slicer there is a text column and doesn 't work fort numeric column
Heard some SKUs to text for this reason
Thanks a lot for putting this video. I like the points that you mentioned in the video. One thing which is not working for me is, I want to sort legends in Time series stacked column chart using a measure in tooltip and it's not working. I tried many methods but it's not giving me desired results. It would be great if you can give some suggestions on this.Thanks !
Great video. PowerBI is becoming better and better, and your videos are a fantastic resource for learning about it. Did you know you can sort any dimension by any field*? You don't need to drag it to the tooltip*? You can also hide columns in tables to avoid seeing them.*
*But only if you use Tableau 😁
You are an awesome trainer/creator/explainer sir. Thanks for your hard work.
Wow! Amazing! A lot of shortcuts and tricks that can make your life easier if you only know about them! Thank you for sharing!
Glad it was helpful!
Nice video as always! I like to do tooltip measure which I use in page icon for example. When choosing which page it should navigate you can just use the measure instead (as long as the name page is the same as the measure). So nice if you have multiple pages and want to change them all at once.
I always look for a video from Bas after power bi updates to see something that surprises power bi users.❤
Great work Bas, just a note 8:55 Feature 6 part 2 On German Keyboard it's Strg(Control) & #
Great video !! Multiple sort is my pick 👍
Actually you can call it measures, but you have to write like this [ Measures ]. The spaces are important.
Btw. Love your videos. Thanks a lot for your valuable input
What??? Double sort with shift key?? game changer...
Thanks!
Just as I thought I mastered Power BI, I learn of the * feature. Genius.
Thanks a lot, Bas, for this useful video on Power BI features which would definitely increase my productivity.
Glad to hear that 😎👊
Very good thanks. Especially searching for all formulas in the language, and double filter. Paul
Hi thanks for the video i have 1 doubt ,My search box is not case sensitive what should i do?
Hello friend, I am a close follower of yours. I would be very happy if you could explain the logic of the Dax formulas in depth. How to write meausure, what should be taken into consideration? I would be very happy if you could make a video about these. I just started this program. I hope that thanks to you, I will love it and I can prepare very good dashboards.
Shift Key to sort table by multiple columns is an absolute game changer!
Thank you for sharing these interesting features.
Very useful and very well explained.
Thank you
Your content is fantastic, thank you for sharing it with us!
@HowtoPowerBI you are nothing short of amazing🥳🥳🥳🥳Thank you so much
Great video. Although i couldn't just drag the measures to my separately created measure table. Trued using shift alt and what not. Please could you help on this
Make sure you are in the modeling view
@@HowtoPowerBI got it now thanks
Number 5 blew my mind, haha i've been using the arrows for ages!!
What can I say? ... Speechless , make more of this please🎉
you are amazing, thank you!
i have on question if i have a filter, this filter contains for example 1000 Item Name
i want to search for computer
the filter will show
10 computer names
how can i select them after filtering?
without holding CTRL and select one by one
Great video full of awesomeness, Bas! Thanks!!
Wow...this is super. I have learnt a lot. Thank you for sharing it. :)
In my experience, the folder layout gets a little funny if you try to create a Measure in a subfolder, it creates a top level folder with the subfolder name. So if you tried to create a new Measure in the Targets\CY folder it would create a new folder called CY.
Feature number 5, I can't believe that was there all along, I was so sure it didn't exist (maybe search result are skewed and only show results for old Power BI ?)
Insightful, learned two new things
So useful... please continue to post informative videos. Thank you!
definitely 🤓💻
super helpful features .Thanks Bas
Great! Can we expect a more frequent uploads?
That’s the plan… that’s always the plan… 🫣
Gracias por tanto amigo Bass, eres un genio!!!!
🤓💻 gracias
I've learned new things! thank you!
Thanks Bas, excellent as always!
Great tips, Bas. Thank you. 😀
Thanks dude!
Thank you! Very helpful!
Glad it was helpful!
Super cool.Feature No 04 is awesome.
I use it a lot .. also very handy to fix sorting issues with parameters (see last vid)
I want another series of this @how to power bi.
Heyy, love your videos! can you do Jitterplot next? thank you!
Hi sir, thank u as always. I always looking forward to your vids - not just for d amazing power bi tips but also to your charm 😊 keep it up sir.
Can you do a video on color and design? Do you use sRGB for editing?
bro this is awesome! thank you for the tips
Many thanks! So obvious but really useful stuff. Keep the brilliant content coming. 💪
More to come! 😁 thx for watching
Very helpful bro @Bas Thanks😊
Power BI Boss - Thank You
💻🤓
I have a Problem in Line chart Visual, I would be grateful if you answer me:
In my line chart, I have 3 and more Line at the same time.
I want to simultaneously see a certain value with a certain X and y on my chart.
that when I do this with the Maesure, because these Line change (in fact, I select the graphs from Slicer), this is not possible, or I don't know. I can't specify this value in the Datalabels(Value and Detail) either, because It shows the values that it has selected automatically. Thank you for replying to my post
Thanks for sharing, amazing bro!
For the multi select, I use Ctrl + F2. I don't know if this has different functionality in any way?
i think it is the same
Very informative, thanks for the video 🎉🎉
You are welcome thx for watching 🤩
Thanks!
You are awesome ¡¡¡ Thans you very much for sharing ¡¡¡
Hi dear, In Power BI the line chart I want to display a certain amount on Chart Line.
I went to Data labels. A cerat a new Measure and use it in Data Labels(Detail).
For example, for y = 50 and shows the value of x.
I don't know why, when I do the same thing for y=10 or 80, it doesn't show it. Thank you for your help.
Why copy paste queries when you can use flows?
How to create show /hide filter pane in a page where there are already multiple bookmarks for showing different visuals. I want the filter pane to work independently without the bookmarks. Can you help me here ?
Cool, thanks!
I have a calc group that contains an item that I need to change the font color of. How do you do that?
So, the calc item looks at the selected measure, i.e. sales, calculates the value for the current year and the previous year, and returns the year over year change. I want it to be red if negative. Seems simple. But it is not the selected measure that I want to format, it is the calculation item result that I want to format. Is this possible?
Love the content
Great video. Thanks
Thanks for watching ! 😀
How to get Properties for a measure in tip 7?
what build is this?
Good job.
Thxs, Bas!
Hallo Bas, weet jij waarom de maand (bijvoorbeeld in een slicer) altijd in het Engels wordt weergegeven, ook al heb ik alle instellingen in Power BI en op de laptop ingesteld op Netherlands?
Really useful!! thank you! Let me know if you can help me with something related with feature 4. Imagine you want to order the olympics medal ranking for all countries.. so you use a stacked bars chart with golden, silver and bronze medals.. ok... so, you can also create measures for the SUM of each one and for the total SUM of medals... Ok. but the issue is that if you pick the golden medals SUM por ordering, then the chart put China before the US since, C comes before U and they are even in golden medals... so the question is.. how to pick total medals as a second criteria of ordering? thand in advance!
This is so useful
😊 happy to hear that !! Thx
Great! 👏👏👏👏
A great Refresher
😎👊
perfect
we still want a video for the funnel chart please
Nice!
Thanks!
8:37
10:09
But why I failed in my attempt at feature 3...
Hold shift key?
🔥
I'm not able to find the sequence on my italian keyboard to comment more rows
I wish Power Query had CTRL+SHIFT+L ... 😞
🤯