Pivot Tables in Power BI !?

[@AhmedSaad-pq3ws]

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!

[@paulwyatt8523]

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]

thanks for sitting all the way through the 26 minutes 😁 .. hopefully it pays off ;)

[@franckybgd93]

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]

especially timed this one for you 😁😉

[@NasreenKariem]

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]

Thank you so much for watching it 😀

[@hamza_Techy]

​@@HowtoPowerBI Biggest Fan Of Yours

[@lubomirjagersky7327]

Ďakujeme.

[@HowtoPowerBI]

thank you so much!!!! 😁

[@alicedwonderland7733]

The Field parameters are a game changer - learned about them from you from a previous video :) Thank you, Bas!

[@wilconagtzaam587]

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!

[@lubomirjagersky7327]

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]

I'm trying 😁 THX!

[@louism.4980]

This is remarkable, thank you for sharing this! :) Also, really impressed how with how far you've come with your video editing skills!

[@HowtoPowerBI]

thx, nice to hear that!! 😁

[@dan.7997]

@Bas your works and workarounds are perfectly amazing!

[@HowtoPowerBI]

I appreciate that! thx Dan

[@roverre61]

Dear Buz, This is really fantastic. Nice way to give control to final users. Well done 👏👏👏

[@danielascibilia4608]

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]

you re a life saver.. thank you for posting at the right time...

[@karthik2244]

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!

[@Fernando_Calero]

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.

[@MrMvlarra]

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 ?

[@wmfexcel]

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?

[@dnielcerqueira]

Great video. Having the outline option to expand categories in the stacked bar chart would be amazing.

[@gwilkins2896]

Awesome job creating the Excel pivot table experience in Power BI.

[@alexama8703]

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!

[@RADR1993hopalong]

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?

[@RobusDobus]

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.

[@rafallipczyk5760]

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.

[@DenverBronx12]

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

[@ali.jawwad]

This is masterpiece and very helpful. You truly are an inspiration!

[@HowtoPowerBI]

thank you!!!!

[@storageofinformation]

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]

Remove label should do it

[@texmexdragon2160]

A masterpiece in instruction and competency Bas. Informative and useful as always.

[@keagankemp6275]

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]

well maybe one day you can use of the tips😁 thx for watching

[@keagankemp6275]

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

[@madinachady5258]

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

[@human001-D1]

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]

Thx , the vid explains how to build it

[@geineralbertomejiagarzon4034]

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.

[@manouchehr777]

Please tell more about Iconmap, for example, how can we design two maps with two layers?

[@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]

Yea just a version thing or make sure to enable on object from preview options

[@trstrean]

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.

[@mahjoubhbib6404]

can you show us how to display text in the pivottable values area please

[@AdamMarks]

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

[@lucasdanti]

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!

[@JayCee90261]

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]

don't you miss sorting?

[@azarroja]

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

[@m.p.9028]

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 👍

[@SirHiss17]

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]

Nobody here likes Excel.

[@HowtoPowerBI]

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]

lol 😁🤣 .. well I'm still using it, or shouldnt I say that out loud here

[@SirHiss17]

@@HowtoPowerBI Completely agree.

[@SirHiss17]

@@datasapien Why would people not like it? It is an extremely useful tool

[@alexgry4763]

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]

havent tried, didnt know of the problem .. will have a look

[@antonycatella5901]

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]

@@antonycatella5901 AI is optional in decomposition tree. It can be turned off completely. But the field parameters still would not work.

[@sanchowitfurrows1561]

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

[@AsmaAlasmary]

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

[@1wasim.akram2]

Can we download raw file for practice. If yes then how can

[@dmitriyivanov1309]

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

[@workstuff5253]

Nice! Auto-expand - yes please!

[@ankit28287]

please if you can explain filter slicers

[@nevermore17011990]

this is, beyond godlike bro ! please do more video about Matrix/Pivot Formatting & Design

[@taitu7538]

as usual, awesome video. thanks

[@pantakarnpuengrang9736]

This is DOVE!!! . You are So CREATIVE!!

[@HowtoPowerBI]

😁🤓💻 thx!

[@SpyCow92]

Amazing! Going to add this to a few of my dashboards now 😄

[@alexrosen8762]

Extremely useful in a lot of real world scenarios 👌🙏👌

[@HowtoPowerBI]

hope it is 😊

[@davidtalbot2061]

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 😂

[@lalitsoni3596]

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]

too wide range of things that it can be to help you on this

[@mrgun4606]

Can you tell me how you recorded your video and edited it. It's amazing and I also want to do it.

[@HowtoPowerBI]

camera and mic next to monitor + screen .. editing with adobe premiere / aftereffects / audition

[@mrgun4606]

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

@@mrgun4606 there are many great content creators on that topic .. here is one to get going kzbin.info/www/bejne/oZbSpK2em5l3kJo

[@mrgun4606]

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

@@mrgun4606 1 video is about 2 days of editing and 1 day of prep

[@emilymalkin270]

Amazing! ❤❤❤

[@YaElDaniels9410]

Tu contenido es oro! Gracias!

[@HowtoPowerBI]

Gracias!

[@oliviahowing9104]

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]

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

[@tonyagamata2874]

Thanks a million for always sharing your expertise. Glad I voted "NO" when you mentioned about stopping PBI vids.haha

[@RohiGupta]

learnt a lot from this!!

[@down_with_data]

Thank you Bas! amazing as always

[@HowtoPowerBI]

thank you 😊

[@SameeK]

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]

How do you knew same requirements I have from user ..you just saved 😊

[@HowtoPowerBI]

yea i think pbi devs run into similar requirements 😅

[@Dasunikarunarathna-m3x]

My master ❤🎉

[@jjdlaa804]

Omg!! I loooooooove this!

[@lukeminikoski]

Awesome!

[@ManojBaghel-j7k]

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]

Pbix with data model is there. See download link i. Description

[@russvetden9342]

Спасибо, друг!

[@gezin_longuevilleosaer4245]

Fantastisch!!

[@HowtoPowerBI]

dankjewel 😁

[@JustRandomExplorer]

Nice idea, thanks!

[@HowtoPowerBI]

Glad you liked it!

[@bangerasiddharth]

amazing!

[@HowtoPowerBI]

thank you !!! 😎👊

[@user-data_junkie]

Goat 🐐

[@HowtoPowerBI]

😊 thx

[@ParvezZamanReza]

No direct way to download the required file for the tutorial. Great initiative. Ultimately just a waste of time.

[@HowtoPowerBI]

The link is in the description

[@hamza_Techy]

​ @HowtoPowerBI Biggest Fan Of Yours