Pivot Tables in Power BI !?

--------------------------------
📊 TRAININGS 📊
---------------------------------

---------------------------------
⏱️ TIMESTAMPS ⏱️
---------------------------------
00:00 Intro
00:30 Why people love pivot tables
01:17 Option 1: Personalized visuals
03:27 Option 2: Let's start with field parameters
05:57 Making it look like in Excel
07:48 Adding icons before the titles
10:23 What about the filters?
11:00 Expand and collapse all levels
16:42 Show fields selection in the title
19:12 Upgrading the look & feel
21:40 Values on rows or columns
25:38 End

---------------------------------
😍 JOIN 😍
----------------------------------

---------------------------------
👇 CHECK THIS OUT! 👇
---------------------------------

* 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

[AhmedSaad-pqws]

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!

[franckybgd]

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

[paulwyatt]

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.

[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 😅

[DenverBronx]

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

[danielascibilia]

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 🥳

[wilconagtzaam]

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!

[alicedwonderland]

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

[gwilkins]

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

[dan.]

@Bas your works and workarounds are perfectly amazing!

[lubomirjagersky]

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

[roverre]

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

[karthik]

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!

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

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

[madinachady]

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

[SirHiss]

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.

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

[alexama]

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!