Top 10 Power BI Features You Should Be Using Right Now!

[@HowtoPowerBI]

datatraining.io/powerbidesigntransformation

[@avirupmitra4694]

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 🙇

[@Sebastian-l5e]

or the cool brother who knows all the awesome skateboard tricks

[@PSAndPowerBI]

haha😂

[@petercheche533]

I think Microsoft sometimes thinks "did we put that?" When he does some stuff.

[@rschloch]

Easily the best teacher in KZbin. I spent a lot of time listening to long-winded tutorials before I stumbled into his channel. It’s great.

[@larl07]

Multiple sort: Shift + click on column. Brilliant! Didn't know this!

[@HowtoPowerBI]

So many of these little features, happy i could show you that one ✌️

[@heyyaziz]

I didnt know we can multi sort. So very helpful!

[@pawansripada]

Do you think column from examples is a little feature? My Entire work time is going to change from now onwards ​@@HowtoPowerBI

[@cesun5452]

yeah this one is insane never knew this!

[@merachewgebremariam5082]

Thanks!

[@samuelvecchio6758]

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

[@szklydm]

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

[@Some_One_Hidden]

You are the king of PowerBi. Never seen some one explain in simple, quick and smart way like you. Thanks tons!

[@mabshane]

How do we like the video more than once.....jaw drop on some of the features 😱

[@dutchinfluencer]

Great stuff! Wildcards and shift, no clue before

[@jakeonash]

Double Sort using the Shift Key ... If only I knew that years ago. Your videos are brilliant.

[@dipongkarroy1720]

You save ton's of time man , you are great...................

[@HowtoPowerBI]

awesome 👊😎

[@stephenkeefe8205]

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 "."

[@JaRyCu]

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.

[@HowtoPowerBI]

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

[@juanp.2061]

Same here!!

[@JaRyCu]

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

[@m.p.9028]

Thanks a lot Bas. Didn't know that you can copy a query from one report to another. This will help a lot 😁👍

[@HowtoPowerBI]

Awesome 🚀✌️

[@edwinarchico439]

What can I say? ... Speechless , make more of this please🎉

[@starkindustries7429]

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).

[@pondyanand]

Great video !! Multiple sort is my pick 👍

[@BM-wp6qe]

Great! 👏👏👏👏

[@josbar80]

Great work Bas, just a note 8:55 Feature 6 part 2 On German Keyboard it's Strg(Control) & #

[@mattsnow2376]

You are an awesome trainer/creator/explainer sir. Thanks for your hard work.

[@bz86054]

Thanks dude!

[@gabatsoswekentse4699]

@HowtoPowerBI you are nothing short of amazing🥳🥳🥳🥳Thank you so much

[@akhileshhalkarni8192]

Didn't know sorting a table based on multiple columns was possible up until now! Thanks.

[@robrayborn1349]

Thank you! Very helpful!

[@HowtoPowerBI]

Glad it was helpful!

[@scottwilliams6741]

Great video full of awesomeness, Bas! Thanks!!

[@xyclos]

Thanks Bas, excellent as always!

[@manojprabhakar7951]

Very Good Features, Thanks for the video

[@gkirankumarskht]

super helpful features .Thanks Bas

[@Nalaka-Wanniarachchi]

Super cool.Feature No 04 is awesome.

[@HowtoPowerBI]

I use it a lot .. also very handy to fix sorting issues with parameters (see last vid)

[@orphee4829]

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

[@elnurmehdizade]

Cool, thanks!

[@zzota]

Great tips, Bas. Thank you. 😀

[@beyondspreadsheets_]

Love the content

[@matthiasg.4941]

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 😁

[@just_pbi]

Wow! Amazing! A lot of shortcuts and tricks that can make your life easier if you only know about them! Thank you for sharing!

[@HowtoPowerBI]

Glad it was helpful!

[@josefedericopresno6668]

Thxs, Bas!

[@extraktAI]

I wish we had a crash course about Power BI in university

[@abdullaamr1028]

Perfect

[@Mulder_93]

Your content is fantastic, thank you for sharing it with us!

[@fanlovexcel]

Very helpful bro @Bas Thanks😊

[@brianhenkels9002]

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.

[@frankjosesuberorodriguez1819]

Thanks for sharing, amazing bro!

[@DominiqueToretto70]

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

[@Milhouse77BS]

Heard some SKUs to text for this reason

[@abazarkin]

🔥

[@PaulEBrownbill]

Very good thanks. Especially searching for all formulas in the language, and double filter. Paul

[@viniciusnaegele7042]

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?

[@ajaaskelainen]

I've learned new things! thank you!

[@kassiowifried]

Good job.

[@nbandeiras]

Power BI Boss - Thank You

[@HowtoPowerBI]

💻🤓

[@guillelopez4222]

Just as I thought I mastered Power BI, I learn of the * feature. Genius.

[@StrikeSven]

Insightful, learned two new things

[@PSAndPowerBI]

perfect

[@MrTintin91]

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.

[@MrMouldybread]

Shift Key to sort table by multiple columns is an absolute game changer!

[@DavidSantiago-xh5jl]

Number 5 blew my mind, haha i've been using the arrows for ages!!

[@narendrababu2287]

I always look for a video from Bas after power bi updates to see something that surprises power bi users.❤

[@gennarocimmino]

Thank you for sharing these interesting features. Very useful and very well explained. Thank you

[@vijaykrishnan4151]

Wow...this is super. I have learnt a lot. Thank you for sharing it. :)

[@santoshhmt]

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?

[@krishna6296]

So useful... please continue to post informative videos. Thank you!

[@HowtoPowerBI]

definitely 🤓💻

[@jamesrosicky2912]

What??? Double sort with shift key?? game changer... Thanks!

[@anudeepboddu999]

Thanks a lot, Bas, for this useful video on Power BI features which would definitely increase my productivity.

[@HowtoPowerBI]

Glad to hear that 😎👊

[@jakemello9121]

bro this is awesome! thank you for the tips

[@Luis.C.Canchan]

Gracias por tanto amigo Bass, eres un genio!!!!

[@HowtoPowerBI]

🤓💻 gracias

[@MucahitKatirci]

Great video. Thanks

[@HowtoPowerBI]

Thanks for watching ! 😀

[@strohmer3464]

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

[@vinayakp4943]

Very informative, thanks for the video 🎉🎉

[@HowtoPowerBI]

You are welcome thx for watching 🤩

[@fpa89]

Nice!

[@HowtoPowerBI]

Thanks!

[@srieeshpadukone]

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

[@HowtoPowerBI]

Make sure you are in the modeling view

[@srieeshpadukone]

@@HowtoPowerBI got it now thanks

[@vinceivanlibao3404]

Heyy, love your videos! can you do Jitterplot next? thank you!

[@mrbartuss1]

Great! Can we expect a more frequent uploads?

[@HowtoPowerBI]

That’s the plan… that’s always the plan… 🫣

[@mrTonYT987]

Many thanks! So obvious but really useful stuff. Keep the brilliant content coming. 💪

[@HowtoPowerBI]

More to come! 😁 thx for watching

[@TrackPace]

Hey, Awesome video as usual! what visual are you using on the first part of the video at the bottom with the time bars?

[@churtado1984]

You are awesome ¡¡¡ Thans you very much for sharing ¡¡¡

[@ertf7777]

I want another series of this @how to power bi.

[@Arowsky]

This is so useful

[@HowtoPowerBI]

😊 happy to hear that !! Thx

[@captivatedCoder]

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.

[@douglascory]

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 ?)

[@YTNutflexPayb]

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.

[@dipankargogoi3773]

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 ?

[@TomGee-n1n]

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?

[@AminSaadatpour-b4b]

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.

[@workstuff5253]

For the multi select, I use Ctrl + F2. I don't know if this has different functionality in any way?

[@HowtoPowerBI]

i think it is the same

[@AminSaadatpour-b4b]

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

[@joyscreations777]

Hi thanks for the video i have 1 doubt ,My search box is not case sensitive what should i do?

[@palanikarthicks5187]

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 !

[@Fannie2uN2010]

A great Refresher

[@HowtoPowerBI]

😎👊

[@pawansripada]

8:37

[@yunusemreaydn9250]

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.

[@wozturner6999]

Why copy paste queries when you can use flows?

[@tarekhusam]

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

[@kubrakivan1579]

How to get Properties for a measure in tip 7?

[@huntermckeown1144]

what build is this?

[@Kylbigel]

Can you do a video on color and design? Do you use sRGB for editing?

[@pawansripada]

10:09

[@azfs1990]

🤯

[@warrenleighnatividad9109]

how do you load the picture to power bi?

[@HowtoPowerBI]

You can use the picture url , set the data category to img and at it to for example a table

[@frankdegooijer99]

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?

[@profemanuperez]

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!

[@abdel7443]

we still want a video for the funnel chart please