Video

Very Clever!!!!! Omg i was racking my brain and could not figure it out. I'm coming from mapping in Tableau which has data labels.

Awesome vid thank you

Hi guys, there is no "average" in the menu. How to fix it?

Very useful method thank you so much👏👏

Excellent examples and explanations. But I have a problem working with Matrix visualisation and using 3-4 level grouping + calculating average values. At the row level everything is fine, but in the final totals and subtotals depending on the level of expanding madness happens. Examples with more complex situations that happen in a real environment would be great.

I’m really trying to learn this with using an Excel Source and an SQL table as my sink destination. I need that SQL table to use that excel file name. Do you have a video for that???

Amazing video, thank you!

The best explanation on ALLSELECTED so far. Keep up the excellent work. I really highly appreciate it. Thank you

2:30 to skip the bullshit

Doing it python works for me. R seems to have issues..

Woooooooow! Genius! Thank you so much, just what I needed.

Wanted to pass along a big thank you! I'm embarrassed on how long not having the correct integration services set in my linked services took me to realize. Thanks for calling that out in your video!

Thank you for the useful video. Can data labels be added using either Shape Map or Mapbox in Power BI?

I am trying to Select the columns based on pipeline parameterrization. Like passing the columns as A+B+C (assuming A,B, C are columns to be selected amount the columns, A,B,C,D,E,F)). Any idea how we can achieve it ?

super 👍 thanks Mit

amazing video , opens the fields of possibilities , thank you for sharing this very useful process

Very well presented! Thank You for the tip!

Thank you Mitchell for this, and communicating the steps to make it work. I have been working in Power Query via Excel, and was struggling to find the "Add Tables from Example" when returning webdata. My search brought me to this page looking for help with power query in Excel, and. I think for others, it's worth noting that this this feature is NOT in Power Query for Excel, only Power BI. Love your videos, love your training style, and I am a Pragmatics works fan, after one of your classes. Keep up the great work!

is there any method to show just the data lables ? i mean just the numerical values without showing the name of the state and showing the datalables at the exact location on the map could you help please ?

Much to like, but why does every Logic App presenter think they have to avoid the 80% use case -- uploading a blob to Azure Storage and triggering an ADF pipeline to put the data into Azure SQL? I seriously could not care less about all these specialty corner cases -- tweets, record-level SQL events, things that happen out on the Great Wild Web... it's all just distraction me. 🙂

Great explanation of concepts on this video.

This works like a charm. Thanks for the solution!

Thank you for the excellent content videos.

Very helpful video... learnt valuable information .. Thank you so much😎😎

Awesome tutorial as usual with the DAX Master. Crystal clear and concise, breaking down and making calculate() just easy like taking breakfast in the morning. Bravo, Michell Peterson!

I have a question Mitchell, how do you connect the Sales by State data with slicer (for example: Year slicer)

Amazing and fantastic explanation!

great tutorial. very useful... thanks.

How can we look at rolling averages over transactions instead of dates?

You are the GOAT!!!

Great video and thanks for taking the time to explain everything in detail. I know this video is a couple years old. Is there a way to not return a 3 month average for the first 2 rows where there is not enough previous data to give 3 month average?

1:43

Hi Mitchel which app are you using to record your video . I want to know how you hid your face when it's blocking the background

Hi, How about changing the column name in excel data file? How to automate this change in power bi?

Really great video! now I am securely able to connect to BLOB storage from ADF. Now, how can I set up a secure connection in self-hosted IR to able to connect to on-premises file shares?

Your explanations are always on point.

Hi, thanks for this video. It has helped me a lot. However, I still have a problem with the source SQL table and the JSON sink. I want one JSON file per record, but I can only generate one JSON file for the entire table. Any hints on how to reference the ID of each record in the file name?

great explanation, really loved this:)

Hello, I'm looking for labels as purely numbers only without any country name mentioned in the label.If anyone has a solution for that it'd be really helpful. Thank You.

This is a very underrated channel!! Super helpful! 🙏🏽

Thank you so much. I was struggling with the same problem and you solve it.

Thank you Mitchell! The best video on CZcams regarding the function.

Hi Mitchell , Well done I like you style and ways of explaining things. Good clear concise explanation of two concepts that can confuse people

Hello Mitchell, I hope you are doing great. By the way, I love your courses and how you explain the concepts with simple terms. With that being said, I am just trying to wrap my head how these Filter functions( ALL, ALLSELECTED & ALLEXCEPT) works. From my general, conceptual understanding, I think it mainly used to control and limit "How" & "What" user can filter, when using external filters such as "SLICERS" & "TIMELINE". Please!!!, feel free to correct me if my conceptual understanding is inaccurate. Thank you.

Many thanks Bro

Nice stuff Mitchell, Very informative. Thanks for taking time and making it wonderful video. I wish if you could add some videos for Azure DataBricks as well 🙂

Awesome thanks!

Hi, how to get the PBIX file for this video? Thanks.

Hello is it possible to dynamically change the column name based on the selected filter. For example I have a language filter English and French and my column names should automatically changedto English and French column names based on the selected filter

I did try this in power pivot and could not get it to work, PBi works a treat, just annoying as I'm more a PP person.