Exploring the SEMANTIC MODEL in Power BI

In this video I go over the new model explorer of the October 2023 Power BI Update. Step by step I show the objects in the semantic model, what they are and practical ways of using them.
Enjoy this video and subscribe to always stay updated on my favorite Power BI tricks :)
Download file here datatraining.io/powerbi-how-to
--------------------------------
📊 TRAININGS 📊
---------------------------------
Power BI Design 4 Weeks Transformation Program my.datatraining.io/pages/powe...
Power BI Essentials datatraining.io/powerbilearni...
Business User Training datatraining.io/powerbi-busin...
For Custom Trainings and Consulting email directly [e-mail]
---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:41 Exploring the Semantic Model
01:38 Calculation Groups
09:12 Cultures
14:06 Perspectives
19:30 Roles
18:30 Hierarchies
21:20 Partitions
27:06 End
---------------------------------
😍 JOIN 😍
----------------------------------
Join bit.ly/4b453bi
Subscribe bit.ly/31MnQGO​
Insta / howtopowerbi
LinkedIn / basdohmen
TikTok / how.to.power.bi
X / howtopowerbi
fb / howtopowerbi
Threads www.threads.net/@howtopowerbi
Newsletter datatraining.io/newsletter
---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------
💻 My gear amzn.to/47F21Yc
📚 Power BI books MUST READ! amzn.to/3tUfFcj
💡 General books I recommend amzn.to/48YNo33
🎶 Music for my videos www.epidemicsound.com/referra...
🚀 For growing on KZbin: www.tubebuddy.com/bas
🏄 Stuff I use daily amzn.to/3HqfMQ2
* Above are affiliate links, which means at no additional cost to you, if you make a purchase using these links we will receive a small commission. It supports us and helps us to continue making more How to Power BI videos!
Thanks for being a part of this channel and all your support! 💪 🙏
#HowToPowerBI​ #PowerBI​ #DataTraining​
#powerbidesktop​ #powerbitraining​ #powerbideveloper​ #DAX

[@CinthyaBlois]

Calculated groups is amaziiiingggg! Thanks for this video :) I downloaded the material and I tested use a field calculations instead one single measure and it works!!!!! Fantastic!!!!

[@tam260]

Thanks for using finance scenarios as an example. We're always dealing with CY, LY, Budget and Forecast and it's often a pain

[@HowtoPowerBI]

I think a lot of people can relate to that 😅

[@TheRealMvV]

@@HowtoPowerBIdo you have a video explaining the other calculation items you skipped (YOY, YTD, etc)?

[@gizemerdemirler7089]

you are the absolute best instructor out there!

[@paulgallagher2987]

Brilliant as always Bas! You've managed to pack so many advanced concepts into half an hour. And explained each perfectly. So useful; thank you.

[@HowtoPowerBI]

thanks again for watching 😁😊 happy it helped a bit

[@500iq6foot8]

Thanks for covering this right away. What I really look forward to is seeing the use cases people come up with over the next couple months

[@HowtoPowerBI]

so many use cases already out there (as everything was already possible before the update)

[@johnbert9480]

I just updated my PowerBI June 2023 version and it is a huge change in my perspective. Thank you so much Bas for putting up videos like this keeping us up to date! 🎉

[@HowtoPowerBI]

😯 just skipping july, aug, and september!? you dare devil 😉

[@redelico1337]

I see what you did there

[@DarlaW]

Love your videos!! I always learn a ton from you!

[@RamzyTheDad]

Thank you for the quick and informative upload! Cheers!

[@HowtoPowerBI]

Yea tried to be quick with this update 😅 glad it was helpful!

[@businessinsights_AlexRobe]

Awesome Video again, Bas - THANKS! @Changing the model to allow Incremental Refresh: when you convert the fact table Date column to datetime: Did you ever come across any issues with the relationship from Date table [Date] to the Datetime-column of the fact table. E.G. filtering, Time intelligence etc. - and if so would you still need an additional date column in the facts table? Thanks again!

[@nbandeiras]

Thank You so Much Bas. You are the BEST Ever. Your videos are always so helpful. Grateful and Regards from Portugal

[@frankgovers8420]

Bas, kudos. Always impressed by your knowledge.

[@umityalcin7888]

Your expression is very clear and straightforward. First and foremost, I would like to extend my congratulations to you. I have acquired a wealth of valuable information through our interaction

[@HowtoPowerBI]

that's very niche to hear! thank you 😊

[@josefedericopresno6668]

Great as always, Bas. Thank You so much!

[@McKaySavage]

Another really great and clear video! Thanks! One issue that came up to me in how you showed calculation groups is that in the matrix, there does not appear to be any header or title that shows the base measure was Actuals vs Forecast. This could lead to problems with end users if someone changes the base measure, forgets to change it back, and the rest of the team goes on making decisions on the report without knowing. Is there some built-in signal on the visual as to the base measure that you didn't show?

[@juliestudy1475]

That's incredible!!! Thanks for sharing!!

[@PowerAnalyst]

Thank you Bas! your videos are so useful for our learning and development. You deserve to be the Microsoft MVP. If possible share us your learning and success path :)

[@hendrik-stack22]

Best comprehensive video on the new features. Thank you very much 😊

[@HowtoPowerBI]

glad to hear that 😊 thx for watchn

[@AnthonyCua]

Thank you so much for going through each and every par of the semantic model. It was so overwhelming at first!

[@HowtoPowerBI]

glad it was helpful 😊 thx for watching!

[@terpstry]

Great informative video! Very clear explained.

[@user-jg2in3eh5l]

Thanks Bas, as always with awesome content!

[@sarveshdeshpande1772]

Great learning ….. thanks Bas for all your hard work !!!

[@HowtoPowerBI]

Always welcome

[@jamesrosicky2912]

This is brilliant! Finally I was able to grasp, how to set up an incremental refresh! Thanks a lot!

[@HowtoPowerBI]

Glad it helped! 😊

[@TheRealOrangeAde]

Thanks Bas, Lots of interesting new elements to work with 🙂

[@HowtoPowerBI]

You bet! lot of model exploring to do 😉

[@LALA-yg7ny]

thanks for sharing, was very helpful. subscribed :)

[@sajadahmadi595]

just brilliant, Thank you so much Bas

[@felipeemmanuel7328]

Excellent video as always master! One question, taking into account the matrix you presented, if you want to present several measures and leave one of them as current and the other measures you present as LY, for example, how can you do this quickly following this logic? I'm from Brazil and my English is still weak, lol. Any questions just ask. Thanks in advance!

[@matthewshotton86]

This is such a game changer for new reports, thanks for all the great content!

[@jose6433]

Thank you for your videos!! Are amazing!!

[@HowtoPowerBI]

Thanks for watching them! 😊

[@edwinarchico439]

Thank you Bas, loaded with good stuff.

[@HowtoPowerBI]

thx!!! 😊 .. definitely nice new feature

[@marupbi]

thanks a lot! great work as always😎

[@murats5863]

I appreciate sharing your knowledge with us, thx!

[@HowtoPowerBI]

thanks for watching 😊

[@user-ef4oc3vc6r]

Thank you for the video. It was very interesting.

[@priyaramjee]

Fantastic video and super helpful for all the finance scenarios as often we end up zillion measures to cover all this periodic calculations for all the scenarios

[@pahadianalyst]

This is freaking Amazingggggg......Both the Semantic Model and BAS. Infact Bas is more awesome as I would not have understood any of it without this video. Thank you Bas

[@eligorniak9699]

Thanks Bas! You're an amazing Teacher!!! 😃😃

[@HowtoPowerBI]

thank you so much, that's really nice to hear 😊

[@jorgedelgado4846]

Muchas gracias!!! excelente información!!!!

[@HowtoPowerBI]

Gracias 🙏

[@papibaquigrafo82]

Awesome video!! Thanks for the content!

[@HowtoPowerBI]

😊😎 thank you

[@IM2a1]

So many measures I could avoid. Will try in a next model. Thanks!

[@MrMumumumu]

Very useful, thank you so much!

[@HowtoPowerBI]

Glad to hear that! thx for watching 😊

[@zelik33]

Great video - big thanks !!

[@HowtoPowerBI]

thank you! 😊

[@user-in3br6dw1r]

H!, Bas I Hope you are good, I Love your Video this the First Time that i have landed on youtube page, Subscribed your in a minute of fraction. You are So Good..... Best Luck.....

[@solangefranco3444]

Really good video! Thanks and please continue sharing interest topics like this ☺

[@HowtoPowerBI]

Sure thing! thanks for watching 😊

[@samanthapikus3178]

Excellent Comprehensive Video!!

[@HowtoPowerBI]

Glad you enjoyed it! thanks 😎👊

[@miguelbenito7992]

Row level security!!! Finally. Thanks

[@HowtoPowerBI]

:p well it was there already, just you can see it now as well in the model explorer

[@sandeepbarge4699]

Hi, thanks for the video. Can you please help me understand, qhen one should use field parameters and when to use calculation groups? Please can u explain the difference in two?

[@FabrizioCiciarelli]

Thanks, you are the best!!! A question, why this pbix file does not found on datatraining?

[@user-gs2fy5nb7d]

this video is fantastic, really useful, thanks!

[@HowtoPowerBI]

Glad it was helpful! thanks a lot 😊

[@user-uz3wq1eg7y]

Learnt a lot from your videos. Thanks Bas

[@HowtoPowerBI]

awesome, glad to hear that 😊

[@mahajanbhushan221]

Awesome explanation. I always wait for your new videos please keep making such wonderful content :)

[@HowtoPowerBI]

Thanks a lot 😊 definitely will

[@arunvignesh1912]

Great video , I have been looking into your videos from the beginning and learnt a lot from you ..thank you so much for the great videos .. This is my first comment.. keep up the good work 👏 👏

[@HowtoPowerBI]

😯🎉 your first comment! .. thanks! 😉 what an honor

[@siddheshamrutkar8684]

This video is awesome but by any chance do you have any videos on handing the unbalanced hierarchies..there are many videos but I have one requirement is that I have to show account ids to respect to that account whenever there are any blanks within the levels.

[@wilconagtzaam587]

Was waiting for a great video from you, instead of going through the Power BI October 2023 Feature Summary Blogpost! Great job as always, I will share the link with my colleagues.

[@HowtoPowerBI]

awesome thanks Wilco. and I was waiting for your comment 😉😁

[@minkelcrondon9727]

Loved the run through, just updated and was wondering how to tackle the new view

[@HowtoPowerBI]

happy it helped 😊 have fun exploring

[@isframew]

Hey bro!, How are you doing?, Greetings from Chile. I have a question about your Power BI Desktop version.. because I updated it the lastest version (October , 23) from the official page, but it keeps showing the add-visual panel in the right side of the screen, not as yours that it's on the top. Could you help me what version should I download and Install, or what I have to do to get it?. Thanks so much for your time bro, I loyal follower here!

[@fedegarcia6526]

Bas, the partitions would work if I have one txt per month and I want to refresh it every month and just add the new month without refreshing the other ones?

[@andresmallama2210]

Hola cómo estás ? Veo tus videos desde Colombia y me has ayudado mucho en mi proceso, Muchísimas gracias por todos tus videos

[@HowtoPowerBI]

muchas gracias.M e alegra oír eso.

[@Victor-eb5vx]

Super video as always but I don't understand one thing. After creating a partition in the model and uploading it to the website. We can't download the model again. In that case will only 1 partition always be visible in power bi dashboard?

[@nirmitshah6162]

Super helpful.❤

[@HowtoPowerBI]

👊😎 Glad you think so! thx 😊

[@YuvarajNarayanan]

Thanks ! Awesome video

[@HowtoPowerBI]

😎👊

[@faizaaniba4595]

Excellent, Wow 😊 thanks for this video, great content as always !

[@HowtoPowerBI]

Thanks again for watching 😊!

[@karinamatvejeva3164]

Thank You 🔥♥️🔥

[@ljgaming1589]

Is it possible to filter off any measure from the calculation group. For example, there are two measures for total sales and total price. There are three calculation items for current, MTD and YTD. When I put the calculation group item in the report, that will display value from both two measures. But I want to display only total sales under current. Do not need MTD and YTD under current. But need to display total sales and total prices both under MTD and MTD. I will be very appreciated your advice. Thank you in advance

[@SynonAnon-vi1ql]

Hi, a question about security and roles in relation to my org's setup. All our power bi reports are built on top of Azure Data warehouse. And we want to implement RBAC based access to data at warehouse level and authenticated with active directory. In this case, do we have to worry about data access at Power BI level? Thank you!

[@Aquaelus]

*our Mentor is back, how wonderful.*

[@HowtoPowerBI]

😎👊 lovely to b back ;)

[@ayushsolanki1068]

Always Fabulous!!

[@HowtoPowerBI]

😎👊😊

[@luigir2459]

Thank you for showing this. Quick question. Are you able to condition format a single part of calculated groups?

[@HowtoPowerBI]

yes you can, there view vids here on youtube and blogs that explain howto

[@raulsanchez3756]

Great job Bas!

[@HowtoPowerBI]

thank you! 😁

[@mneama4383]

You don’t have any weak content , all is great ❤❤❤❤❤

[@HowtoPowerBI]

🤗

[@firetawgc]

Amazing!

[@HowtoPowerBI]

Thank you! Cheers! 👊😎

[@luisfernandomacedo1451]

Awesome Bass!

[@MinhTamNguyen-jd3uz]

Thanks for this tutorial. Very useful! Actually, one of the drawbacks with calculation group in reality is that in the case of using user customization which users are mostly PBI beginners (or even little knowledge), it's very challenging for them to drop & drag the correct wanted measures & understand how it works.

[@HowtoPowerBI]

in think in most organizations those people would be consuming the reports that are created for them

[@dc-sg8ot]

Does cultures handle date? So we get UK week Monday to Sunday and also not UTC when uploaded to service

[@muhammetmuslu4429]

Great. Thanks

[@HowtoPowerBI]

😊

[@user-du8ol2us7h]

Is there anyway in power bi import by mean of which I can only update the data which have been changed or inserted in back date.

[@carstenbuchmann2077]

Danke!

[@gilaniseye4267]

Thanks Bas for all your hard work! 5:55 Could we apply group calculations for the 2 measures (Rev Actual & Forecast) in the same table/matrix? In your example, you only showed the case for one measure (Rev Actual OR Forecast) Again, thanks a lot for all the brilliant work!

[@HowtoPowerBI]

Yes you can! 😁 thx for watchn

[@megabuilds3007]

​@@HowtoPowerBI How it can be? Do we need to add measures in calc group? If so we are again creating all the measures right? 🤔

[@dutch-man]

Try using a Field Parameter 😀

[@yulingo5577]

Create one column in the table where Actual- forecast and use the column as selected value

[@777tmack]

Your calculated groups were conveniently named such that sorting was not required. However, in my case, the names are not as intuitive. Is there a way to sort them?

[@reinaldoc.]

Wow, Great!

[@HowtoPowerBI]

yes finally we can see it in PowerBI - was about time 😁

[@herambjoshi8546]

Thank you Bas for creating such an awesome content for PowerBI. One quick question, would Calculation group work simultaneously for 2 measures or it has to be 1 selected measure at a time?

[@HowtoPowerBI]

yes it would :)

[@dannyyin3273]

@@HowtoPowerBI I was hoping to use a Parameter to toggle among several measures, say Rev, Margin, COGS and show only one set of each measure (CY, LY, YoY, YoY%) at a time, but the Values field won't take Parameter. Any thoughts on how to get around that? BTW, brilliant presentation, love it!

[@tomfisher1099]

This was your best video yet

[@HowtoPowerBI]

yey 🎉 :p depends how you measure it though ;)

[@JohnOttoKnoke]

Great video, as always, Baz. Please make a video explaining how to use Power BI (.pbip) save options. Herzliche Grüße aus Guatemala

[@HowtoPowerBI]

Thanks for the idea! will put it on my list 😁

[@DISISNOTFAIR]

the problem with calculations groups i faced 2 years ago and i believe its still there is that you cant do conditional formatting as much as you would like. lets say we have calculation group for current period, prior period and % difference. Now highlighting green/red for the % is pretty painful.

[@HowtoPowerBI]

is possible though

[@user-qj7dp6lx2t]

Big question about calculation groups - why can’t I sort the columns in a matrix visual?? This is a show stopper for me…

[@Milhouse77BS]

ahh, partitions! Thanks!

[@gayatrilshinde1560]

thanks!

[@HowtoPowerBI]

thx for watchn 😊

[@chelseazhang0708]

Thanks alot, but the powerbi file download page shows error, can you check it

[@alienbotofficial]

Nice one!

[@timestoryx]

Cool 🎉🎉🎉

[@HowtoPowerBI]

😎👊

[@devod4000]

This new change is great. Thanks Bas.

[@joelvargas8397]

I really like how you explain things. Are you able to do some consulting?

[@HowtoPowerBI]

Let me know your email, we will be in touch

[@user-hy9dw4vo4f]

Hi, I have a transaction table in power bi,where Two Years Data(Jan-22 to Dec-23),I need cumulative of this amount in matrix with column?(Month-year) with a condition like need cumulative calculation from start of month year and also we have a slicer like Last Year,This Year ,when I select from slicer this year the give last month of previous year values Add with this year values & which month values in (-) they Give Total Cumulative, can you solve this issues, Because it's giving same as we need through Date slicer ,when we use the formula for This year and use in slicer they not give results according to us

[@arthurvanrijn68]

Nice !

[@HowtoPowerBI]

very nice new feature! :) thx for watching

[@cassimpilodia918]

Hi is calculation groups possible in Power Bi Report Server Version

[@peterhelms-nielsen8838]

Hi Bas. At 7:16 you forgot to insert the link to the formatting video - just thought you would like to know ;). Great video as always.

[@HowtoPowerBI]

aaaah totally forgot! thank you so much for pointing it out

[@peterhelms-nielsen8838]

@@HowtoPowerBINo problem. Keep up the good work - it is soooo inspiring.

[@jamalelbouatmani3728]

Good morning Thank you for your videos are really very interesting, I have a question: to export the Dashboard to Power Point without publishing it on the Power bi service, is there a way to do it Thanks in advance

[@HowtoPowerBI]

no dont think that is possible

[@Drengen10]

Does cultures also affect things such as timezones (especially with regards to summer/winter time) and comma/dot for decimal seperator?

[@HowtoPowerBI]

no for timezones you probably need a solution like this -> kzbin.info/www/bejne/roDNaH6EpsqSmassi=AB-n3VQdfvKCuiv8

[@RohithN10]

Bas, Check out the custom labels in data labels, its not working for many.

[@YannickSOUSSOU]

Hello Bas. Hope you're good. A part from the content, I like the way you share the screen. What Apps do you use please?

[@HowtoPowerBI]

thanks a lot :) editing is done in premiere pro, animations in after effect, and audition for the sound

[@YannickSOUSSOU]

@@HowtoPowerBI Thanks for the reply.

[@YannickSOUSSOU]

@@HowtoPowerBI please, what do you use to record your screen ?

[@jevonzhu]

nice work bro

[@HowtoPowerBI]

😎👊

[@amankasera4212]

Can you show how the "Role" option in "Model" helps to set up dynamic row level security more easily

[@HowtoPowerBI]

no, still works in the same way

[@nininya]

Can we use these calc groups in a slicer?

[@HowtoPowerBI]

Yes 🙂