Quick tip for bulk editing the DAX, if you use the keyboard shortcut Ctrl + F2 (or Ctrl + Shift + L) after you have selected the 1st "financials[Date]", it will select all versions of that wording and you can overtype them in one move.
You are just like a WOwww. I did your powerbi course from Udemy and it was Awesome and because of that course I got a data analyst position at UK based company. Thanks a bunch.
Wow, stumbled upon a Chris Dutton video! I've been learning from you over 10 yeas. I still reference your FoodMart Solution File. Much respect Chris, your LinkedIn training made my career!
Absolutely fabulous run through of the New Card. I am a Power BI instructor, and need to show the New Card to my learners next week. Do I show it myself or just show them this visual (and let them see how a master does it)? Tricky decision.
This is a great tutorial Chris! Thank you so much for sharing your knowledge. :) QQ though - the details formula works absolutely great in the desktop but when i publish to the service i get - - instead. Ideas?
Thanks for the video! I followed your steps, created new card and added few reference labels. When I did that, the first top of the card is so massive, you can’t see any of the reference label data below the devider. I have to make the card almost as big as my whole dashboard for all the info to be visible. How can I adjust it? Ideally I would want to move the devider up, so the rest of the data shows up. Any ideas?
Just had to google a bit, sorry. STARTOFMONTH(DateTime[DateKey]) It is a standart DAX script, in my case I wanted start of the week and used this line StartOfWeek = [Date] + 1 - WEEKDAY([Date], 2) This works for weeks that start on Monday, also careful with it for the weeks that start/end on the border of the year.
Thanks a lot for the video I followed through but somehow the context filter of start month is applying even to the reference labels and not displaying values for previous month How do I work around this?
I figured out how to make calendars and measures of my data since this video didn't cover that portion. I was able to successfully make two new card visuals based on data sets that have a row for every day. The Start of Month filter works fine on those to sort my data by month when I have two months of data and there is data for each day. When I try to use a data set to filter by Start of Month , and the data it is filtering does not have a row for every day of that time period, I get two dashes instead of a value. I'm still looking online to see if I can find a solution but if you could assist that would be greatly appreciated.
I enjoyed your video. Thanks for sharing. One question I have is... where can I find the list of unicodes that includes 129129 and 129131. I am unable to find any codes in that range. And then I am hoping that there are other similar codes that I could peruse. Thanks!
Hey, great video - I am following along whilst using my own data. Does anyone know how he created things like "previous month revenue" etc? Thank you @Chris-at-Maven