Pivot Tables in Power BI !?

  Рет қаралды 65,425

How to Power BI

How to Power BI

Күн бұрын

Пікірлер: 123
@AhmedSaad-pq3ws
@AhmedSaad-pq3ws 5 ай бұрын
I have been following your videos since 1.5 years and will never stop watching your tips and tricks in PBI, Iam super happy to find this channcel as it was one of the reasons i had a good job opportunity in Germany. Thanks alot Bas ! you are very successful person and a very good example of professional workers!
@franckybgd93
@franckybgd93 7 ай бұрын
You are truly the best. I just started my working day with the idea of ​​proposing a "Custom Analysis" section in one of my power bi reports. I connected to KZbin to start my research and your video had only just been published. You are a genius 👏🏿👏🏿
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
especially timed this one for you 😁😉
@paulwyatt8523
@paulwyatt8523 7 ай бұрын
I've just gotten around to watching this and was initially worried to see 26+ mins. The detail you've put in, and time take to identify the shortcomings, is astounding. This is something I was looking to implement but had no idea how to approach, and then your video dropped. I will consider making this 'feature' available to clients but I am going to build it into production reports for the project leads to immediately analyse the data and provide clarity to stakeholder/client queries. This is going to save so much time, especially with not having to export to Excel first.🤩 Thank you so much Bas.
@HowtoPowerBI
@HowtoPowerBI 6 ай бұрын
thanks for sitting all the way through the 26 minutes 😁 .. hopefully it pays off ;)
@NasreenKariem
@NasreenKariem 7 ай бұрын
You are honestly BOSS!!! Its not only your content, but it is the manner in which you deliver the content 👏👏👏 Trully amazing and appreciate your hours of work to make us look good out there 😅
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
Thank you so much for watching it 😀
@hamza_Techy
@hamza_Techy 4 ай бұрын
​@@HowtoPowerBI Biggest Fan Of Yours
@louism.4980
@louism.4980 6 ай бұрын
This is remarkable, thank you for sharing this! :) Also, really impressed how with how far you've come with your video editing skills!
@HowtoPowerBI
@HowtoPowerBI 6 ай бұрын
thx, nice to hear that!! 😁
@alicedwonderland7733
@alicedwonderland7733 7 ай бұрын
The Field parameters are a game changer - learned about them from you from a previous video :) Thank you, Bas!
@wilconagtzaam587
@wilconagtzaam587 6 ай бұрын
Great video as always! Cool thing is that since I did your course I much better understand your way of thinking and of how to solve issues. It still helps me every day!
@dan.7997
@dan.7997 7 ай бұрын
@Bas your works and workarounds are perfectly amazing!
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
I appreciate that! thx Dan
@lubomirjagersky7327
@lubomirjagersky7327 7 ай бұрын
Perfect, as usual. I appreciate the time you put into it, and the fact that you never settle for "good" but always take it up a level
@HowtoPowerBI
@HowtoPowerBI 6 ай бұрын
I'm trying 😁 THX!
@danielascibilia4608
@danielascibilia4608 7 ай бұрын
My boss is always asking for a Pivot, but I prefer use Power BI, that is the perfect compromise!!! Thank you very much!!! I love it 🥳
@Niyasudheeak
@Niyasudheeak 7 ай бұрын
you re a life saver.. thank you for posting at the right time...
@lubomirjagersky7327
@lubomirjagersky7327 7 ай бұрын
Ďakujeme.
@HowtoPowerBI
@HowtoPowerBI 6 ай бұрын
thank you so much!!!! 😁
@roverre61
@roverre61 5 ай бұрын
Dear Buz, This is really fantastic. Nice way to give control to final users. Well done 👏👏👏
@dnielcerqueira
@dnielcerqueira 7 ай бұрын
Great video. Having the outline option to expand categories in the stacked bar chart would be amazing.
@gwilkins2896
@gwilkins2896 4 ай бұрын
Awesome job creating the Excel pivot table experience in Power BI.
@DenverBronx12
@DenverBronx12 7 ай бұрын
Very cool solution. I tried this myself but quickly realized that your values must be measures. A standard matrix will automatically allow you to apply "sum of ..." but in order for this to work you need to create the equivalent measure to do that
@karthik2244
@karthik2244 6 ай бұрын
Thank you! Great explanation. One of the challenge I had is with sorting, we couldn't sort by the selected columns. When we select one value and sort by Jan 2019 or sort by Jan 2020, is that possible? Thanks for your help and the great learning videos to the PowerBI community!
@RADR1993hopalong
@RADR1993hopalong 2 ай бұрын
This functionality is really amazing! I am applying it to some of my dashboards and I want to also use the labels too. When it comes to the labels and bringing out what is selected, I want the order of the values shown to be based on the order in which it is selected so that it is clear (especially for the rows section) how the data is broken out in the pivotable. How would I update the measure to order the way the subtitle shows based on the selection order?
@Fernando_Calero
@Fernando_Calero 2 ай бұрын
Thank you for sharing @Bas. Q: How could you force the values to don't show blanks and save space in the matrix, based on the fact that the user might use any of the possible measures available? I can't just go to the filter pane and choose a measure to filter non blanks, because there are any measures selected yet.
@texmexdragon2160
@texmexdragon2160 7 ай бұрын
A masterpiece in instruction and competency Bas. Informative and useful as always.
@ali.jawwad
@ali.jawwad 6 ай бұрын
This is masterpiece and very helpful. You truly are an inspiration!
@HowtoPowerBI
@HowtoPowerBI 6 ай бұрын
thank you!!!!
@keagankemp6275
@keagankemp6275 7 ай бұрын
Wow, love this. I have very little use for it but every time I get other tips that I never use so love your content.
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
well maybe one day you can use of the tips😁 thx for watching
@keagankemp6275
@keagankemp6275 7 ай бұрын
@@HowtoPowerBI no I am definitely using them think I should send you some of my reports so you can snag them lol, I just tell people when you come to powerbi forget everything you think you know about excel lol
@wmfexcel
@wmfexcel 5 ай бұрын
WOW... you really know it inside out! great video! May I know if there is a way to put the column grand total to the left of the report instead?
@alexama8703
@alexama8703 4 ай бұрын
Hello, Thanks for your videos!! What if I want allow the user to not select any column? So having the posibility to having the matrix only with Rows and Values? Thanks!
@MrMvlarra
@MrMvlarra 7 ай бұрын
Amazing video! I have just one more question…. Is there any way to see the gran total on top when it is selected the tabular format ?
@mahjoubhbib6404
@mahjoubhbib6404 21 күн бұрын
can you show us how to display text in the pivottable values area please
@storageofinformation
@storageofinformation 7 ай бұрын
Hi Bas. Great work and easy to follow. Question: the first icon you placed (calendar) it looks like you have some left-over in front of the icon it (10:20). It looks like a pipe but can also be a capital I. in the next shot with all the icons it was gone. Greetings from NL.
@nicolajpetersen4673
@nicolajpetersen4673 7 ай бұрын
Remove label should do it
@RobusDobus
@RobusDobus 5 ай бұрын
Hi Bas, great video! I am trying to implement this for a client, but I would like to have the filter section dynamically show different filters based on the selected fields in the rows and column section. Do you know a solution for this? I saw your other video on dynamic slicers with field parameters, but that only works with one selected value in a field parameter, not if you select multiple values.
@geineralbertomejiagarzon4034
@geineralbertomejiagarzon4034 7 ай бұрын
Absolutely amazing!!!, at first I thought, well this is about using the new features of the matrix, but it was not like that, it'was much better. Thank you.
@dullestower8773
@dullestower8773 15 күн бұрын
You have 2018 data in your DB (in the PBIX download) but I don't see this data in your dashboards. Not sure if you filtered it out. Please advise.
@trstrean
@trstrean 7 ай бұрын
Awesome video! I was just working on a pivot table and this video helped me work out an issue I was encountering. I love your channel, but could you do a back to basics video? Canvas size and selecting a size seems really important with significant consequences depending on how the report is used. I made the mistake of increasing canvas size so I could get a font size that looked smaller than what was possible with the default limit of 8 (add a visual or two to the page) not realizing I would lose the ability to copy visuals. Another basic is losing subscription to reports when the page is hidden. Maybe you are aware of workarounds for some of the basics. Setup decisions seem to have future impacts that aren't always obvious and aren't well advertised.
@manouchehr777
@manouchehr777 7 ай бұрын
Please tell more about Iconmap, for example, how can we design two maps with two layers?
@m.p.9028
@m.p.9028 7 ай бұрын
Very nice, thats what i also already implemented in my reports. But now I know also how to export/colapse more or less automatcally. Thx for that 👍
@rafallipczyk5760
@rafallipczyk5760 4 ай бұрын
Will the bookmarks work with different combination of objects selected? Your saved bookmark for "Expand All" was set for a specific combination of objects and when you tested it you used the same objects again.
@human001-D1
@human001-D1 4 ай бұрын
This looks amazing, where can I find the option with the box to drag in data. It doesn’t seem to show on my power bi. Is this a new version?
@HowtoPowerBI
@HowtoPowerBI 4 ай бұрын
Thx , the vid explains how to build it
@SirHiss17
@SirHiss17 7 ай бұрын
Excellent video for showing what is possible but the complexity of setting this up is exactly why people go to Excel. I am not sure how long it took to set this up but this is about a minute of work once the data is in Excel for an average Excel user.
@datasapien
@datasapien 7 ай бұрын
Nobody here likes Excel.
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
many things take longer in power bi to set up. power bi offers many benefits which make people to prefer sometimes to have their reporting in pbi instead of excel. depends on what requirements you have for your reporting
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
lol 😁🤣 .. well I'm still using it, or shouldnt I say that out loud here
@SirHiss17
@SirHiss17 7 ай бұрын
@@HowtoPowerBI Completely agree.
@SirHiss17
@SirHiss17 7 ай бұрын
@@datasapien Why would people not like it? It is an extremely useful tool
@madinachady5258
@madinachady5258 5 ай бұрын
You're a life saver Boss ;) but how can i add a date slicer for example if i choose February the data only for feb chooses or changes
@nevermore17011990
@nevermore17011990 7 ай бұрын
this is, beyond godlike bro ! please do more video about Matrix/Pivot Formatting & Design
@ankit28287
@ankit28287 3 ай бұрын
please if you can explain filter slicers
@SpyCow92
@SpyCow92 7 ай бұрын
Amazing! Going to add this to a few of my dashboards now 😄
@dmitriyivanov1309
@dmitriyivanov1309 6 ай бұрын
I just want to add that it will be a good idead to group rows and columns, so users can see product attributes in one section, store attributes in second group and calendar attributes in a third one. And It is a dangerous video because users like pivot table very much!!)))
@Joanna-h9f
@Joanna-h9f Ай бұрын
I love your videos. I have question regarding Pivot tables in Power BI. On my PBI desktop in the visual pivot table there is no option "Layout and style presets" there is only "style presets" . Why? Is it old version of PBI?
@HowtoPowerBI
@HowtoPowerBI Ай бұрын
Yea just a version thing or make sure to enable on object from preview options
@taitu7538
@taitu7538 6 ай бұрын
as usual, awesome video. thanks
@AdamMarks
@AdamMarks 7 ай бұрын
We have done something similiar but the biggest challenge is the Totals vs No Totals at a field level. Is there any way for the end user to toggle totals on and off, field by field? Haven't been able to figure out how to make that user defined in published report
@pantakarnpuengrang9736
@pantakarnpuengrang9736 7 ай бұрын
This is DOVE!!! . You are So CREATIVE!!
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
😁🤓💻 thx!
@JayCee90261
@JayCee90261 6 ай бұрын
Only thing the PBI matrix is missing is the ability to move the values into their only sections instead of them group together in one period, like shown at 22:03. Makes it difficult to view data
@sanchowitfurrows1561
@sanchowitfurrows1561 6 ай бұрын
don't you miss sorting?
@1wasim.akram2
@1wasim.akram2 2 ай бұрын
Can we download raw file for practice. If yes then how can
@workstuff5253
@workstuff5253 7 ай бұрын
Nice! Auto-expand - yes please!
@AsmaAlasmary
@AsmaAlasmary 3 ай бұрын
It didn't work for me because these options apply for power bi (cloud version). Do you know different options for (Server version)? Thank you ..
@nguyenthihuong755
@nguyenthihuong755 8 күн бұрын
I don't see the build panel on my PBI report. Could you guide me how to turn on?
@HowtoPowerBI
@HowtoPowerBI 8 күн бұрын
Maybe you are a viewer without editing rights?
@HowtoPowerBI
@HowtoPowerBI 8 күн бұрын
Open the report in pbi desktop
@lucasdanti
@lucasdanti 7 ай бұрын
Hello, my friend! Do you have any video on your channel about your power bi configuration or something like that? Because I liked your power bi interface! Greetings from Brazil! Your videos help a lot!
@azarroja
@azarroja 7 ай бұрын
Hi @Bas , I have followed your steps created value parameter , in my source table the column type is number but when create value parameter it’s changed to text . Can you help me how to fix that
@alexrosen8762
@alexrosen8762 7 ай бұрын
Extremely useful in a lot of real world scenarios 👌🙏👌
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
hope it is 😊
@down_with_data
@down_with_data 7 ай бұрын
Thank you Bas! amazing as always
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
thank you 😊
@YaElDaniels9410
@YaElDaniels9410 7 ай бұрын
Tu contenido es oro! Gracias!
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
Gracias!
@tonyagamata2874
@tonyagamata2874 6 ай бұрын
Thanks a million for always sharing your expertise. Glad I voted "NO" when you mentioned about stopping PBI vids.haha
@davidtalbot2061
@davidtalbot2061 7 ай бұрын
This is really neat and I know my customers would love it but really just continuing letting them export to excel is simply the easier solution and probably better visually despite your amazing efforts with your report. I hope Power BI improve the Matrix and Table visuals... despite my best efforts they are what my customers want 😂
@RohiGupta
@RohiGupta 6 ай бұрын
learnt a lot from this!!
@alexgry4763
@alexgry4763 7 ай бұрын
Hello Bas. I have tried using a field parameter as a breakdown dimension in a decomposition tree. Sadly, it didn't work properly. PBI does recognize parameter selection in a tree, but the tree is buggy and system crashes if you try expanding the leaves in an order different from the order I select parameter fields. Somehow order of selection begins to matter... I have discovered this issue back in 2022 when the field parameters have been introduced. As of my knowledge, nobody in the World could make it work so far and that is sad, since decomposition tree imao beats pivot table as a tool for analysis. Have you ever tried solving this issue Bas?
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
havent tried, didnt know of the problem .. will have a look
@antonycatella5901
@antonycatella5901 6 ай бұрын
Decomposition Tree is an AI visual and AI visuals / Q&A are listed as 1 of the limitations of field parameters on the Microsoft website
@alexgry4763
@alexgry4763 6 ай бұрын
@@antonycatella5901 AI is optional in decomposition tree. It can be turned off completely. But the field parameters still would not work.
@sanchowitfurrows1561
@sanchowitfurrows1561 6 ай бұрын
Yeah, order of selection matters. User can select City then Country and get rows hierarchy where City is on top and country is under the City. A bit confusing
@lalitsoni3596
@lalitsoni3596 6 ай бұрын
Hello sir ,i need your help, on a website i got a pyscript to a steaming dataset access ,i have API credentials n all but when i try to run that pyscirpt to get data in powerbi its not allowing me to get access, please help me out 🙂
@HowtoPowerBI
@HowtoPowerBI 6 ай бұрын
too wide range of things that it can be to help you on this
@oliviahowing9104
@oliviahowing9104 7 ай бұрын
Nice video! Could you make a video (if you haven't already how to use bookmarks to toggle between Yearly/Quarterly/Monthly Date-Granularity? I am currently using Parameters to achieve that, but maybe Bookmarks are more efficient.
@antonycatella5901
@antonycatella5901 6 ай бұрын
I have used both Field parameters and bookmarks to do what you are doing and have found little difference in performance. The big difference is in dev time to setup and maintain bookmarks. Field parameters are so much easier to add / remove options
@mrgun4606
@mrgun4606 7 ай бұрын
Can you tell me how you recorded your video and edited it. It's amazing and I also want to do it.
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
camera and mic next to monitor + screen .. editing with adobe premiere / aftereffects / audition
@mrgun4606
@mrgun4606 7 ай бұрын
@@HowtoPowerBI Thankyou 🤗. Actually I want to edit like you. Could you make a video how you edit if possible. I want to use it for my data analyst portfolio project video or recommend some videos which can help me.
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
@@mrgun4606 there are many great content creators on that topic .. here is one to get going kzbin.info/www/bejne/oZbSpK2em5l3kJo
@mrgun4606
@mrgun4606 7 ай бұрын
@@HowtoPowerBI Thankyou for recommendation, Just one last question? How you zoom power bi particular section. If it's edit how much time does it take to edit one video? And again thanks for guidance.🙂
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
@@mrgun4606 1 video is about 2 days of editing and 1 day of prep
@emilymalkin270
@emilymalkin270 3 ай бұрын
Amazing! ❤❤❤
@ManojBaghel-j7k
@ManojBaghel-j7k 6 ай бұрын
Hi Bas, I am requesting you to please upload the data you are making a report and then I am practicing as per video & data. Thdnks
@HowtoPowerBI
@HowtoPowerBI 6 ай бұрын
Pbix with data model is there. See download link i. Description
@SameeK
@SameeK 7 ай бұрын
As you said visuals should show what you're trying to illustrate. Stakeholders that wont a pivot table experience, its better to create a "databook" in excel that connects straight to the PowerBI datasets with pre populated pivot tables. All they have to do is click refresh everytime they open it
@gayatrilshinde1560
@gayatrilshinde1560 7 ай бұрын
How do you knew same requirements I have from user ..you just saved 😊
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
yea i think pbi devs run into similar requirements 😅
@JustRandomExplorer
@JustRandomExplorer 7 ай бұрын
Nice idea, thanks!
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
Glad you liked it!
@jjdlaa804
@jjdlaa804 7 ай бұрын
Omg!! I loooooooove this!
@Dasunikarunarathna-m3x
@Dasunikarunarathna-m3x 29 күн бұрын
My master ❤🎉
@gezin_longuevilleosaer4245
@gezin_longuevilleosaer4245 6 ай бұрын
Fantastisch!!
@HowtoPowerBI
@HowtoPowerBI 6 ай бұрын
dankjewel 😁
@lukeminikoski
@lukeminikoski 3 ай бұрын
Awesome!
@russvetden9342
@russvetden9342 6 ай бұрын
Спасибо, друг!
@user-data_junkie
@user-data_junkie 7 ай бұрын
Goat 🐐
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
😊 thx
@bangerasiddharth
@bangerasiddharth 7 ай бұрын
amazing!
@HowtoPowerBI
@HowtoPowerBI 7 ай бұрын
thank you !!! 😎👊
@ParvezZamanReza
@ParvezZamanReza 2 ай бұрын
No direct way to download the required file for the tutorial. Great initiative. Ultimately just a waste of time.
@HowtoPowerBI
@HowtoPowerBI 2 ай бұрын
The link is in the description
@hamza_Techy
@hamza_Techy 4 ай бұрын
​ @HowtoPowerBI Biggest Fan Of Yours
3 Power BI Visuals You Haven't Seen Before!
17:19
How to Power BI
Рет қаралды 54 М.
Understanding the Evolution of Your DAX within Power BI Semantic Models
31:47
Geordie Intelligence #PowerBI
Рет қаралды 67
coco在求救? #小丑 #天使 #shorts
00:29
好人小丑
Рет қаралды 120 МЛН
Мен атып көрмегенмін ! | Qalam | 5 серия
25:41
Sigma Kid Mistake #funny #sigma
00:17
CRAZY GREAPA
Рет қаралды 30 МЛН
A Simple Way to Make 2025 Your Best Year (Free Tool Included)
8:27
How to Create Outstanding Power BI Reports (A Must Watch!)
14:11
3 Hacks to Work Faster in Power BI
25:39
How to Power BI
Рет қаралды 71 М.
1 Trick for Endless Power BI Charts!
20:14
How to Power BI
Рет қаралды 78 М.
The ULTIMATE Slicer Panel in Power BI
36:15
How to Power BI
Рет қаралды 215 М.
What is a semantic model?
4:46
metaphacts
Рет қаралды 4,4 М.
Top 3 Survey Visuals in Power BI
25:25
How to Power BI
Рет қаралды 36 М.
Best Pivot Table Design Tips to Impress Anyone
12:18
Kenji Explains
Рет қаралды 252 М.
3 Ways to use Calculation Groups You Need to Know
20:00
How to Power BI
Рет қаралды 86 М.
Improve the Look and Feel of Tables and Matrix in Power BI
14:00
coco在求救? #小丑 #天使 #shorts
00:29
好人小丑
Рет қаралды 120 МЛН