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!

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 😅

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 KZfaq to start my research and your video had only just been published. You are a genius 👏🏿👏🏿

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.

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

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

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

@Bas your works and workarounds are perfectly amazing!

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!

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 🥳

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

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

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

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

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

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

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.

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

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

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!

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?

Nice! Auto-expand - yes please!

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.

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 ?

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.

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 👍

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

learnt a lot from this!!

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.

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

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

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

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

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 😂

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!

Ďakujeme.

as usual, awesome video. thanks

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.

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

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

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

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.

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

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.

Tu contenido es oro! Gracias!

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.

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

Thank you Bas! amazing as always

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

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

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?

Nice idea, thanks!

Fantastisch!!

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

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

Omg!! I loooooooove this!

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 🙂

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

Goat 🐐

amazing!

​ @HowtoPowerBI Biggest Fan Of Yours